Re: How to get a result in one row

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to get a result in one row
Date: 2006-06-21 18:06:55
Message-ID: 5.2.1.1.0.20060621140420.04580180@pop6.sympatico.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

At 11:06 AM 6/21/06, virgi(at)lettere(dot)unipd(dot)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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Broersma Jr 2006-06-21 18:24:41 Re: How to get a result in one row
Previous Message Jeff Frost 2006-06-21 17:57:24 Re: keeping last 30 entries of a log table