Re: Table Pivot

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