Concatenating several rows - Mailing list pgsql-novice

From Pierre Thibaudeau
Subject Concatenating several rows
Date
Msg-id 74b035bb0701291849w60e84a6anf7151a1b0e39dece@mail.gmail.com
Whole thread Raw
Responses Re: Concatenating several rows
List pgsql-novice
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...

pgsql-novice by date:

Previous
From:
Date:
Subject: Re: Thanks All! - Seconded
Next
From: "George Pavlov"
Date:
Subject: Re: Concatenating several rows