| From: | "Kuldeep Tanna" <kuldeep(at)cse(dot)ogi(dot)edu> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Crosstab function Problem |
| Date: | 2003-09-03 00:13:52 |
| Message-ID: | 01f701c371b0$41cb6f60$7c325f81@crook |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
I am having problem using the crosstab function ( which is under the contrib/tablefunc directory). I have installed the tablefunc module and also installed the functions into my DB.
I am using postgresql 7.4 beta version.
I am issuing the following query,
select *
from crosstab(
'select path,name,value
from file f, metadata m
where f.id = m.file_id
and f.type=1
order by 1,2;',3)
AS DP(name text,runid text, plottype text,region text) ;
I am getting the following error message.
No function matches the given name and argument types. You may need to add explicit typecasts.
I also issued the given example in the tablefunc directory and it gave the same error.
Help me out with this,
Kuldeep.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nigel J. Andrews | 2003-09-03 00:29:08 | Re: Querying $libdir |
| Previous Message | Nigel J. Andrews | 2003-09-02 23:54:28 | Querying $libdir |