romelgomez/array_of_arrays.sql

Forked from AnjaneyuluBatta505/array_of_arrays.sql

Created April 3, 2023 20:18

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/romelgomez/2776df1338bfbdbb8c4f3ea05c33f9a3.js"></script>
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