From: | "George Pavlov" <gpavlov(at)mynewplace(dot)com> |
---|---|
To: | "Pierre Thibaudeau" <pierdeux(at)gmail(dot)com>, <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Concatenating several rows |
Date: | 2007-01-30 03:30:02 |
Message-ID: | 8C5B026B51B6854CBE88121DBF097A867DC932@ehost010-33.exch010.intermedia.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
make it an array first:
SELECT array_to_string(array(SELECT name FROM pseudonyms WHERE
person_id=125), ' ');
> -----Original Message-----
> From: pgsql-novice-owner(at)postgresql(dot)org
> [mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of
> Pierre Thibaudeau
> Sent: Monday, January 29, 2007 6:50 PM
> To: pgsql-novice(at)postgresql(dot)org
> Subject: [NOVICE] Concatenating several rows
>
> SELECT name FROM pseudonyms WHERE person_id=125;
>
> I know in advance that this query yields between 0 and 5 rows of
> results, depending on the actual person_id.
>
> How can I concatenate those results into one text string?
> Something like:
>
> SELECT array_to_string( (SELECT name FROM pseudonyms WHERE
> person_id=125), ' ');
>
> which doesn't work...
>
From | Date | Subject | |
---|---|---|---|
Next Message | Pierre Thibaudeau | 2007-01-30 04:10:20 | Re: Concatenating several rows |
Previous Message | Pierre Thibaudeau | 2007-01-30 02:49:56 | Concatenating several rows |