Function array_flatten

fn array_flatten(array: ListRef<'_>, ctx: &Context) -> Result<ListValue>

Flattens a nested array by concatenating the inner arrays into a single array. Only the outermost level of nesting is removed. For deeper nested arrays, call array_flatten multiple times.

Examples:

query T
select array_flatten(array[array[1, 2], array[3, 4]]);
----
{1,2,3,4}

query T
select array_flatten(array[array[1, 2], array[]::int[], array[3, 4]]);
----
{1,2,3,4}

query T
select array_flatten(array[array[1, 2], null, array[3, 4]]);
----
{1,2,3,4}

query T
select array_flatten(array[array[array[1], array[2, null]], array[array[3, 4], null::int[]]]);
----
{{1},{2,NULL},{3,4},NULL}

query T
select array_flatten(array[[]]::int[][]);
----
{}

query T
select array_flatten(array[[null, 1]]::int[][]);
----
{NULL,1}

query T
select array_flatten(array[]::int[][]);
----
{}

query T
select array_flatten(null::int[][]);
----
NULL