Re: Nested query performance issue

2009/4/9 Віталій Тимчишин <tivv00@gmail.com>:
> OK, got to my postgres. Here you are:
>
> 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;
> $$
> language sql immutable;
>

in 8.4, this will be replaced by the built in 'unnest'.  Also we have array_agg.

merlin