What is a fastest way to unwrap array into rows in PostgreSQL? i.e.
We have:
a
-
{1,2}
{2,3,4}
And we need:
b
-
1
2
2
3
4
I'm use:
select explode_array(a) as a from a_table;
where explode_array is:
create or replace function explode_array(in_array anyarray) returns setof anyelement as
$$
select ($1)[s] from generate_series(1,array_upper($1, 1)) as s;
$$
Is any better way?
