Re: Question about SQL Transform - Pivot - Mailing list pgsql-novice

From Nabil Sayegh
Subject Re: Question about SQL Transform - Pivot
Date
Msg-id 1058219357.561.1.camel@billy
Whole thread Raw
In response to Question about SQL Transform - Pivot  ("John K. Herreshoff" <jkherr@centurytel.net>)
List pgsql-novice
Am Mon, 2003-07-14 um 22.56 schrieb John K. Herreshoff:
> Microsoft Access has an SQL routine Transform - Pivot for generating cross tab
> queries.  Does PGSQL have similar functionality?

Yes, see in the contribs from Joe Conway.
it's called tablefunc and works with >=7.3

bye
--
 e-Trolley Sayegh & John, Nabil Sayegh
 Tel.: 0700 etrolley /// 0700 38765539
 Fax.: +49 69 8299381-8
 PGP : http://www.e-trolley.de


pgsql-novice by date:

Previous
From: "John K. Herreshoff"
Date:
Subject: Question about SQL Transform - Pivot
Next
From: Rasputin
Date:
Subject: Re: Practical SQL Handbook