From: Joe Conway <mail@joeconway.com>
To: Vic Cekvenich <maillist@basebeans.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Table Pivot
Date: Sun, 16 Feb 2003 20:02:55 -0800
Message-ID: <3E505EEF.8070003@joeconway.com> (raw)
In-Reply-To: <007a01c2d5de$a2958880$6e00a8c0@dell150>
References: <007a01c2d5de$a2958880$6e00a8c0@dell150>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mail@joeconway.com, maillist@basebeans.com
Subject: Re: Table Pivot
In-Reply-To: <3E505EEF.8070003@joeconway.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox