Re: return 1 formatted result instead of multiple results

From: Rodrigo De León <rdeleonp(at)gmail(dot)com>
To: Acm <alextabone(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: return 1 formatted result instead of multiple results
Date: 2007-09-02 21:04:41
Message-ID: a55915760709021404l5c9c0c14lbfd3beeccee82cf9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8/31/07, Acm <alextabone(at)gmail(dot)com> wrote:
> and I want one result to be "Mike,John,Dennis".

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2007-09-02 21:08:55 Re: Postgresql 7.3 on Red Hat Enterprise 5 (Problem with SEMMNI, SEMMNS)
Previous Message Idan Miller 2007-09-02 09:05:54 Re: PostgreSQL with Kerberos and Active Directory