On Nov 10, 2011, at 8:22, Henry Drexler <alonup8tb(at)gmail(dot)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