On Dec 11, 2011, at 19:40, Robert James <srobertjames@xxxxxxxxx> wrote: > I have a query returning: > > name | product_id > Bob | 1 > Bob | 2 > Charles | 1 > Charles | 4 > > To make it compatible with a legacy app, I need to convert it to this form: > name | product_ids > Bob | "1,2" > Charles | "1,4" > > (Before you jump "That's not normal!" - I know. I didn't write the > app. I just need to meet its interface.) > > What's the best way to do this in Postgres? Is there a way to do it > via pure SQL? > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general Look at the STRING_AGG aggregate function. David J. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
