Re: generic way to retrieve array as rowset - Mailing list pgsql-general

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
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===