--array_cat(anyarray, anyarray)
--array_union(anyarray, anyarray)
--array_union_distinct(anyarray, anyarray)
--array_intersect(anyarray, anyarray)
SELECT array_cat(ARRAY[1,2,3], ARRAY[4,5]) AS RESULT1
,array_union(ARRAY[1,2,3], ARRAY[3,4,5]) AS RESULT2
,array_union_distinct(ARRAY[1,2,3], ARRAY[3,4,5]) AS RESULT3
,array_intersect(ARRAY[1,2,3], ARRAY[3,4,5]) AS RESULT4
|