Re: Combining several rows

Matthias Nagl wrote:
> Hello List!
> 
> I would like to combine the contents of several rows of a subquery. After 
> several hours of search in the documentation and the internet I didn'T find a 
> solution and hope anyone can help. My problem:
> 
> 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

Joe Conway's crosstab() function in the 'tablefunc' contrib 
directory of the source tree is probably what you want. If you've 
installed by RPM, the postgresql-contrib package will have installed 
the SQL script to initialize the function in 
/usr/share/pgsql/contrib/tablefunc.sql.

HTH,

Mike Mascari