"Flattening" query result into columns

From: "Thomas Borg Salling" <tbs(at)navicon(dot)dk>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: "Flattening" query result into columns
Date: 2005-03-21 21:57:13
Message-ID: 20050321215723.E79E356388@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Leif B. Kristensen 2005-03-21 22:37:08 Re: "Flattening" query result into columns
Previous Message Bruno Wolff III 2005-03-21 15:17:35 Re: query