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@xxxxxxxxxxxxxxxxxxx>, andreas.kretschmer@xxxxxxxxxxxxxx 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 >
