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

From Thomas Borg Salling
Subject "Flattening" query result into columns
Date
Msg-id 20050321215723.E79E356388@svr1.postgresql.org
Whole thread Raw
Responses Re: "Flattening" query result into columns  (PFC <lists@boutiquenumerique.com>)
Re: "Flattening" query result into columns  ("Leif B. Kristensen" <leif@solumslekt.org>)
Re: "Flattening" query result into columns  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-sql
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB" style="font-size:
10.0pt;font-family:Arial">I am looking for a way to ”flatten” a query result, so that rows are ”transposed” into
columns,just as asked here for oracle:</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"><a
href="http://groups.google.dk/groups?hl=da&lr=&client=firefox-a&rls=org.mozilla:en-US:official&selm=aad10be0.0401292322.7b6c320b%40posting.google.com">http://groups.google.dk/groups?hl=da&lr=&client=firefox-a&rls=org.mozilla:en-US:official&selm=aad10be0.0401292322.7b6c320b%40posting.google.com</a></span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB" style="font-size:
10.0pt;font-family:Arial">Is there any way to do this with pgsql  ?</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span lang="EN-GB" style="font-size: 
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">Thanks,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">/Thomas.</span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span
style="font-size:
12.0pt"> </span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:
12.0pt"> </span></font></div>

pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: query
Next
From: "Sean Davis"
Date:
Subject: Re: "Flattening" query result into columns