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 - Mailing list pgsql-general

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;