ryanguill · December 21, 2016 16:41 · NewEXE · Mar 13, 2019 · drmatthewclark · Nov 3, 2020
diff --git a/postgres-merge-arrays.sql b/postgres-merge-arrays.sql
 CREATE OR REPLACE FUNCTION mergeArrays (a1 ANYARRAY, a2 ANYARRAY) RETURNS ANYARRAY AS $$

 	SELECT ARRAY_AGG(x ORDER BY x)
 	FROM (
 		SELECT DISTINCT UNNEST($1 || $2) AS x
 	) s;

 $$ LANGUAGE SQL STRICT;
	CREATE OR REPLACE FUNCTION mergeArrays (a1 ANYARRAY, a2 ANYARRAY) RETURNS ANYARRAY AS $$

	SELECT ARRAY_AGG(x ORDER BY x)
	FROM (
	SELECT DISTINCT UNNEST($1 \|\| $2) AS x
	) s;

	$$ LANGUAGE SQL STRICT;