Skip to content

Instantly share code, notes, and snippets.

@romelgomez

romelgomez/array_of_arrays.sql

Forked from AnjaneyuluBatta505/array_of_arrays.sql
Created April 3, 2023 20:18
Show Gist options
  • Save romelgomez/2776df1338bfbdbb8c4f3ea05c33f9a3 to your computer and use it in GitHub Desktop.
Save romelgomez/2776df1338bfbdbb8c4f3ea05c33f9a3 to your computer and use it in GitHub Desktop.
Download ZIP
merge array of arrays in postgresql with array_agg
Raw
array_of_arrays.sql
--select ARRAY(select distinct unnest(array_agg(category.arr)))
select ARRAY(select distinct unnest(array[array[1,2,3], array[4,2,8]]))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment