需求
CREATE OR REPLACE FUNCTION “bi”.“zip”(“array1” anyarray, “array2” anyarray)
RETURNS “pg_catalog”.“anyarray” AS $BODY$
SELECT
ARRAY_AGG(ARRAY[a,b])
FROM unnest(array1,array2) x(a,b);
$BODY$
LANGUAGE sql VOLATILE
COST 100
版本PostgreSQL 9.4及以上