Matthias Nagl <pg@mnagl.de> writes:
> Let's say I've got a table in the following form:
> SELECT * FROM test;
> id | name
> -----------
> 1 | abc
> 2 | def
> 3 | ghi
> For a table like this I am looking for a query that returns a result that
> looks this way:
> name
> -------------
> abc, def, ghi
The easy way to do this is with a user-defined aggregate. I believe
there are several threads in the mailing list archives that give
solutions to exactly this problem. I tried "create aggregate comma"
at http://www.pgsql.ru/db/pgsearch/ and got this as the first hit:
http://archives.postgresql.org/pgsql-sql/2003-03/msg00381.php
regards, tom lane