Whit Armstrong <armstrong.whit@xxxxxxxxx> wrote: > That's exactly what I needed. Thanks very much! If you have 8.4, you can use the build-in function array_agg() instead: test=*# select * from x; a | b ---+--- 1 | 1 1 | 2 1 | 3 2 | 1 2 | 4 (5 Zeilen) Zeit: 0,203 ms test=*# select a, array_agg(b) from x group by a; a | array_agg ---+----------- 1 | {1,2,3} 2 | {1,4} (2 Zeilen) Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general