[GENERAL] Re: plpgsql, I have a solution, want to see if there is a cleaner/better one. Taking vertical list and comma separating it onto a row

[Thomas Kellerer]

Henry Drexler, 10.11.2011 14:22:

I am thinking there is a better/simpler way, though this is what I have working:

(postgres 9.1)


I would like to have the list of colors for each type of clothing to be comma 
seperated in the end result.

like this:

type        organized_by_type
pants     red, blue, orange
shirt       black, gray

CREATE TABLE clothes
(
   type character varying,
   color character varying
)

SELECT type,
       string_agg(color, ',') as organized_by_type
FROM clothes
GROUP BY type;



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general