Skip to content

Instantly share code, notes, and snippets.

@davidfetter
davidfetter / 1.sql
Created June 19, 2014 17:54 — forked from yawboakye/1.sql
CREATE OR REPLACE FUNCTION fessup.fetch_posts_for_my_timeline(
fesser_id bigint,
last_id bigint DEFAULT 0,
newer boolean DEFAULT true
)
RETURNS SETOF fessup.all_posts
AS $$
BEGIN
RETURN QUERY
WITH
*** a/src/backend/executor/nodeModifyTable.c
--- b/src/backend/executor/nodeModifyTable.c
***************
*** 1451,1453 **** ExecReScanModifyTable(ModifyTableState *node)
--- 1451,1505 ----
*/
elog(ERROR, "ExecReScanModifyTable is not implemented");
}
+
+ void SimpleInsertTuple(Relation relation, HeapTuple tuple)
@davidfetter
davidfetter / djb2.sql
Last active December 26, 2015 03:49 — forked from BYK/djb2.js
CREATE OR REPLACE FUNCTION djb2_hash(string text)
RETURNS bigint
IMMUTABLE
STRICT
LANGUAGE sql
AS $$
WITH RECURSIVE t(seed, string) AS (
VALUES (
87049::bigint,
$1