Concatenate rows - Mailing list pgsql-novice

From A Gilmore
Subject Concatenate rows
Date
Msg-id 42193A40.2090508@shaw.ca
Whole thread Raw
Responses Re: Concatenate rows
Re: Concatenate rows
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Expensive where clause
Next
From: "Mike G."
Date:
Subject: Re: Concatenate rows