Re: Question about SQL Transform - Pivot

From: Nabil Sayegh <postgresql(at)e-trolley(dot)de>
To: "John K(dot) Herreshoff" <jkherr(at)centurytel(dot)net>
Cc: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Question about SQL Transform - Pivot
Date: 2003-07-14 21:49:18
Message-ID: 1058219357.561.1.camel@billy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Rasputin 2003-07-15 16:06:54 Re: Practical SQL Handbook
Previous Message John K. Herreshoff 2003-07-14 20:56:02 Question about SQL Transform - Pivot