On Nov 10, 2011, at 8:22, Henry Drexler <alonup...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
