X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EE51856392 for ; Mon, 21 Mar 2005 21:57:31 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 82836-10 for ; Mon, 21 Mar 2005 21:57:25 +0000 (GMT) Received: from navicon.dk (cpe.atm1-0-1091060.0x50a3778a.arcnxe1.customer.tele.dk [80.163.119.138]) by svr1.postgresql.org (Postfix) with ESMTP id E79E356388 for ; Mon, 21 Mar 2005 21:57:23 +0000 (GMT) Received: from Spartacus (10.0.1.131:3354) by raptus.navicon.dk with [XMail 1.18 (Linux/Ix86) ESMTP Server] id for from ; Mon, 21 Mar 2005 22:57:25 +0100 From: "Thomas Borg Salling" To: Subject: "Flattening" query result into columns Date: Mon, 21 Mar 2005 22:57:13 +0100 Organization: NAVICON A/S MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0074_01C52E69.54F73CA0" X-Mailer: Microsoft Office Outlook, Build 11.0.6353 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Thread-Index: AcUuYPAwb0ESLSlDTxyE4Hl8Qor7FA== Message-Id: <20050321215723.E79E356388@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.849 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, HTML_MESSAGE, MSGID_FROM_MTA_ID X-Spam-Level: * X-Archive-Number: 200503/288 X-Sequence-Number: 20767 This is a multi-part message in MIME format. ------=_NextPart_000_0074_01C52E69.54F73CA0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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.040129232 2.7b6c320b%40posting.google.com Is there any way to do this with pgsql ? Thanks, /Thomas. ------=_NextPart_000_0074_01C52E69.54F73CA0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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=3Dda&a= mp;lr=3D&client=3Dfirefox-a&rls=3Dorg.mozilla:en-US:official&= selm=3Daad10be0.0401292322.7b6c320b%40posting.google.com

Is there any way to do this with pgsql = ?

Thanks,

/Thomas.

------=_NextPart_000_0074_01C52E69.54F73CA0--