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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
