2009/4/9 Віталій Тимчишин <tiv...@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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
