Re: Combining several rows

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