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

On Nov 10, 2011, at 8:22, Henry Drexler <alonup8tb@gmail.com> wrote:

> 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
>
>
>

Use the STRING_AGG aggregate function instead of writing your own.

David J