Re: How to get a result in one row - Mailing list pgsql-sql

From Frank Bax
Subject Re: How to get a result in one row
Date
Msg-id 5.2.1.1.0.20060621140420.04580180@pop6.sympatico.ca
Whole thread Raw
In response to How to get a result in one row  (virgi@lettere.unipd.it)
Responses Re: How to get a result in one row
List pgsql-sql
At 11:06 AM 6/21/06, virgi@lettere.unipd.it wrote:
>returns:
>    id | nick
>------+------
>22192 | A
>22192 | T
>(2 rows)
>
>I'd like to get the result in only one row:
>    id | nick
>------+------
>22192 | A,T


This question is in the archives (probably more than once).  The answer is...

Read the online docs about aggregate functions.  There is an example that 
does (almost) exactly what you are asking.



pgsql-sql by date:

Previous
From: Jeff Frost
Date:
Subject: Re: keeping last 30 entries of a log table
Next
From: Richard Broersma Jr
Date:
Subject: Re: How to get a result in one row