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 === ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
