Re: different unnest function [SOLVED]

From: Ondrej Ivanič <ondrej(dot)ivanic(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: different unnest function [SOLVED]
Date: 2011-09-18 22:32:33
Message-ID: CAM6mieLRvpjgFrHGLWLnxvqr8TpLqyotxf26n+ge5iCo8GnVgQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)ivanic(at)gmail(dot)com)

Browse pgsql-general by date

  From Date Subject
Next Message Toby Corkindale 2011-09-19 00:38:25 Re: PostgreSQL benchmarked on XFS vs ZFS vs btrfs vs ext4
Previous Message Dave Cramer 2011-09-18 20:17:26 Re: Alternative JDBC driver