Hello,

If I have a table like :

ID COLOR
1 blue
2 red
3 green

Could I write a SQL query that would return a single concatenated row
for all matching rows, with a specified seperator. For example like so :

blue:red:green:

Thank you for your time,
A Gilmore

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org