Postgres Pro
Downloads
Home   >   mailing lists

Re: return 1 formatted result instead of multiple results - Mailing list pgsql-general

From Rodrigo De León
Subject Re: return 1 formatted result instead of multiple results
Date
Msg-id a55915760709021404l5c9c0c14lbfd3beeccee82cf9@mail.gmail.com
Whole thread Raw
In response to return 1 formatted result instead of multiple results  (Acm <alextabone@gmail.com>)
List pgsql-general
Tree view 
On 8/31/07, Acm <alextabone@gmail.com> wrote:
> and I want one result to be "Mike,John,Dennis".

SELECT ARRAY_TO_STRING(ARRAY(SELECT * FROM PEOPLE),',') AS FOO

pgsql-general by date:

Previous
From: Patryk Kordylewski
Date:
Subject: Re: ERROR: table row type and query-specified row type do not match
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: Postgresql 7.3 on Red Hat Enterprise 5 (Problem with SEMMNI, SEMMNS)