X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id BC10B475461
	for <pgsql-sql@postgresql.org>; Sun, 16 Feb 2003 23:04:55 -0500 (EST)
Received: from joeconway.com (63-210-180-150.skyriver.net [63.210.180.150])
	by postgresql.org (Postfix) with ESMTP id 1E003474E53
	for <pgsql-sql@postgresql.org>; Sun, 16 Feb 2003 23:04:55 -0500 (EST)
Received: from [192.168.5.3] (account jconway HELO joeconway.com)
	by joeconway.com (CommuniGate Pro SMTP 4.0.4)
	with ESMTP-TLS id 1613526; Sun, 16 Feb 2003 20:39:58 -0800
Message-ID: <3E505EEF.8070003@joeconway.com>
Date: Sun, 16 Feb 2003 20:02:55 -0800
From: Joe Conway <mail@joeconway.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.2.1) Gecko/20021130
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Vic Cekvenich <maillist@basebeans.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Table Pivot
References: <007a01c2d5de$a2958880$6e00a8c0@dell150>
In-Reply-To: <007a01c2d5de$a2958880$6e00a8c0@dell150>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/362
X-Sequence-Number: 11760

Vic Cekvenich wrote:
>>based) approach, take a look at crosstab() in
>>contrib/tablefunc.
> 
> I looked but could not find.
> Where Can I find this?
> 
[...snip...]
> 
> Cool, if I can find a link to compiling the Crosstab
> function.

Well, as I said above, it's in contrib/tablefunc. First off, it is only 
available in PostgreSQL 7.3.x. If you are installing from source, start 
at the top of the postgres source tree and type:

   cd contrib/tablefunc
   make
   make install

See README.tablefunc for more details, and
   contrib/tablefunc/expected/tablefunc.out
as a source of examples.

If you are installing from binary, look for where "contrib" is 
installed. For example, if installing from RPM, make sure you have the 
postgresql-contrib package installed.

HTH,

Joe