Re: How to get a result in one row
От
Frank Bax
Тема
Re: How to get a result in one row
Дата
Msg-id
5.2.1.1.0.20060621140420.04580180@pop6.sympatico.ca
Ответ на
How to get a result in one row (virgi@lettere.unipd.it)
Список
Дерево обсуждения
How to get a result in one row virgi@lettere.unipd.it
Re: How to get a result in one row Frank Bax <fbax@sympatico.ca>
Re: How to get a result in one row Richard Broersma Jr <rabroersma@yahoo.com>
Re: How to get a result in one row Frank Bax <fbax@sympatico.ca>
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 по дате отправления
