2009/4/9 Віталій Тимчишин <tivv00(at)gmail(dot)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