[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    [GENERAL] return 1 formatted result instead of multiple results
From:       Acm <alextabone () gmail ! com>
Date:       2007-08-31 8:41:43
Message-ID: 1188549703.682362.232990 () q4g2000prc ! googlegroups ! com
[Download RAW message or body]

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.


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
[prev in list] [next in list] [prev in thread] [next in thread]