Concatenate rows

From: A Gilmore <agilmore(at)shaw(dot)ca>
To: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Concatenate rows
Date: 2005-02-21 01:32:48
Message-ID: 42193A40.2090508@shaw.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Mike G. 2005-02-21 03:34:27 Re: Concatenate rows
Previous Message Stephan Szabo 2005-02-19 15:11:56 Re: Expensive where clause