Re: generic way to retrieve array as rowset

Thank you both, I will make good use of this.

On a side note: isn't it a pity this has to be so difficult?

Balázs

In article <20060103151044.GF9478@webserv.wug-glas.de>,
andreas.kretschmer@schollglas.com says...
> am  03.01.2006, um 16:42:08 +0200 mailte Volkan YAZICI folgendes:
> > Hi,
> >
> > Here's a modified version of A. Kretschmer's answer. This one checks
> > array_upper() sizes and depending on it, doesn't provide unnecessary
> > NULL fields. HTH.
> >
> > SELECT id, val[s.i]
> > FROM t7
> > LEFT JOIN
> >     (SELECT g.s
> >         FROM generate_series(1,
> >             (SELECT max(array_upper(val, 1)) FROM t7)) AS g(s)
> >     ) AS s(i)
> >     ON (s.i <= array_upper(val, 1));
>
> Cool ;-)
>
>
> Andreas
>