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

From Acm
Subject return 1 formatted result instead of multiple results
Date
Msg-id 1188549703.682362.232990@q4g2000prc.googlegroups.com
Whole thread Raw
Responses Re: return 1 formatted result instead of multiple results
List pgsql-general
I want to query a column in a table that returns multiple records,
append the values of that column in a comma separated string, and
return that string.

example:  select * from people;
returns 3 results:
  Mike
  John
  Dennis

and I want one result to be "Mike,John,Dennis".

How can I format my results in this way using SQL (preferably not
stored functions)?

Thank you.


pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: WAL to RAW devices ?
Next
From: john_sm
Date:
Subject: Open Source Application Server (PostgreSQL Perspective)