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(dot)GF9478(at)webserv(dot)wug-glas(dot)de>,
andreas(dot)kretschmer(at)schollglas(dot)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
>