Thread: Re: different unnest function [SOLVED]

Re: different unnest function [SOLVED]

From
Ondrej Ivanič
Date:
Hi,

> to get the output OP wants, you need to expand and rewrap:
> create or replace function unnest2(anyarray) returns setof anyarray AS
> $BODY$
> select array(select unnest($1[i:i])) from
> generate_series(array_lower($1,1), array_upper($1,1)) i;
> $BODY$
> language 'sql';

Yup, this is what I need. Thanks


--
Ondrej Ivanic
(ondrej.ivanic@gmail.com)