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