| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | Vic Cekvenich <maillist(at)basebeans(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Table Pivot |
| Date: | 2003-02-17 04:02:55 |
| Message-ID: | 3E505EEF.8070003@joeconway.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | betty | 2003-02-17 04:57:37 | trigger after with cursor |
| Previous Message | Tomasz Myrta | 2003-02-16 23:18:21 | Re: Trigger that will execute external program |