alastaircoote · September 15, 2016 16:25
diff --git a/aggregator.sql b/aggregator.sql
 CREATE OR REPLACE FUNCTION jsonb_merge_state(jsonb, jsonb)
 returns jsonb
 language sql
 as $$
    SELECT $1 || $2
 $$;

 DROP AGGREGATE IF EXISTS jsonb_merge(jsonb);

 CREATE AGGREGATE jsonb_merge(jsonb) (
    SFUNC = jsonb_merge_state,
    STYPE = jsonb,
    INITCOND = '{}'
 )
	CREATE OR REPLACE FUNCTION jsonb_merge_state(jsonb, jsonb)
	returns jsonb
	language sql
	as $$
	SELECT $1 \|\| $2
	$$;

	DROP AGGREGATE IF EXISTS jsonb_merge(jsonb);

	CREATE AGGREGATE jsonb_merge(jsonb) (
	SFUNC = jsonb_merge_state,
	STYPE = jsonb,
	INITCOND = '{}'
	)