Postgres Pro
Downloads
Home   >   mailing lists

Re: "Flattening" query result into columns - Mailing list pgsql-sql

From Sean Davis
Subject Re: "Flattening" query result into columns
Date
Msg-id 002d01c52e6d$93e02360$1f6df345@WATSON
Whole thread Raw
In response to "Flattening" query result into columns  ("Thomas Borg Salling" <tbs@navicon.dk>)
List pgsql-sql
Tree view
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 -----
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:

http://groups.google.dk/groups?hl=da&lr=&client=firefox-a&rls=org.mozilla:en-US:official&selm=aad10be0.0401292322.7b6c320b%40posting.google.com

 

Is there any way to do this with pgsql  ?

 

Thanks,

/Thomas.

 

 

pgsql-sql by date:

Previous
From: "Thomas Borg Salling"
Date:
Subject: "Flattening" query result into columns
Next
From: Theo Galanakis
Date:
Subject: C function extending postgres