Re: Denormalizing via SQL - Mailing list pgsql-general

From David Johnston
Subject Re: Denormalizing via SQL
Date
Msg-id 1526E53F-3972-4042-AB19-F9C940D1E10D@yahoo.com
Whole thread Raw
In response to Denormalizing via SQL  (Robert James <srobertjames@gmail.com>)
List pgsql-general
On Dec 11, 2011, at 19:40, Robert James <srobertjames@gmail.com> 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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

Look at the STRING_AGG aggregate function.

David J.

pgsql-general by date:

Previous
From: Stefan Keller
Date:
Subject: Howto to clear PostgreSQL cache and how to preload all tuples of a table into the cache?
Next
From: Robert James
Date:
Subject: Controlling complexity in queries