| From: | "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov> |
|---|---|
| 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-21 23:27:41 |
| Message-ID: | 002d01c52e6d$93e02360$1f6df345@WATSON |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Thomas,
You probably want a crosstab. There is a contributed module in contrib/crosstab. If you do a search of the postgres mailing lists, there will be several posts relating to the same issue.
Sean
----- Original Message -----
From: Thomas Borg Salling
To: pgsql-sql(at)postgresql(dot)org
Sent: Monday, March 21, 2005 4:57 PM
Subject: [SQL] "Flattening" query result into columns
I am looking for a way to "flatten" a query result, so that rows are "transposed" into columns, just as asked here for oracle:
Is there any way to do this with pgsql ?
Thanks,
/Thomas.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonathan Daugherty | 2005-03-22 00:21:13 | Re: C function extending postgres |
| Previous Message | Theo Galanakis | 2005-03-21 22:46:39 | C function extending postgres |