| From: | PFC <lists(at)boutiquenumerique(dot)com> |
|---|---|
| To: | "Thomas Borg Salling" <tbs(at)navicon(dot)dk>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: "Flattening" query result into columns |
| Date: | 2005-03-22 00:35:15 |
| Message-ID: | op.sn0jw1c8th1vuj@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
You could use the array_accum aggregate. See examples in the docs.
On Mon, 21 Mar 2005 22:57:13 +0100, Thomas Borg Salling <tbs(at)navicon(dot)dk>
wrote:
> I am looking for a way to "flatten" a query result, so that rows are
> "transposed" into columns, just as asked here for oracle:
>
> http://groups.google.dk/groups?hl=da
> <http://groups.google.dk/groups?hl=da&lr=&client=firefox-a&rls=org.mozilla:e
> n-US:official&selm=aad10be0.0401292322.7b6c320b%40posting.google.com>
> &lr=&client=firefox-a&rls=org.mozilla:en-US:official&selm=aad10be0.040129232
> 2.7b6c320b%40posting.google.com
>
>
> Is there any way to do this with pgsql ?
>
>
> Thanks,
>
> /Thomas.
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2005-03-22 00:46:17 | Re: "Flattening" query result into columns |
| Previous Message | Jonathan Daugherty | 2005-03-22 00:21:13 | Re: C function extending postgres |