davidfetter

ROLLUP

SELECT count(a), sum(b), count(c) FROM table1 GROUP BY ROLLUP(a,b,c);

Grouping order:

GROUP BY (a,b,c)
GROUP BY (a,b)
GROUP BY (a)
GROUP BY ()

davidfetter

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