Flatten an array of arrays in postgres to a single array

Question

Given something such as the following:

select array[array[1, 2], array[3, 4]]

Which returns

{{1,2},{3,4}}

I would like to know how to flatten this to a single array as:

{1,2,3,4}

user3738870 · Accepted Answer · 2022-11-07 16:55:58Z

2

This is one way to achieve it:

select array(select unnest(array[array[1, 2], array[3, 4]]));

Result:

{1,2,3,4}

answered Nov 7, 2022 at 16:55

user3738870

1,6502 gold badges16 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1