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
From
David Johnston
Subject
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
From:
Henry Drexler Date: Subject:
Re: 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
