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
>
