From: | Tim Clarke <tim(dot)clarke(at)manifest(dot)co(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How can I use crosstab functons in PostgreSQL 9.3? |
Date: | 2015-10-15 14:30:51 |
Message-ID: | 561FB89B.50001@manifest.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Looks to me like argument types possibly? The article creates various
combinations of crosstab() function but you are passing in a query. Wrap
your query in quotes (and then escape those within it). Then you'll be
passing in a "text" type not an "unknown" as the error clearly shows.
Tim Clarke
On 15/10/15 15:19, Tom Lane wrote:
> Rob Richardson <RDRichardson(at)rad-con(dot)com> writes:
>> I am trying to learn about crosstab functions in ProgreSQL 9.3, but none of the examples I’ve found are working. I get errors claiming the functions are unknown, but when I try running CREATE EXTENSION tablefunc, I am told that its methods already exist.
> This looks like a search_path problem. You could try "\dx+ tablefunc"
> to see which schema its functions are in, then adjust your search_path
> to include that, or else schema-qualify the function names.
>
> regards, tom lane
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Richardson | 2015-10-15 14:39:25 | Re: How can I use crosstab functons in PostgreSQL 9.3? |
Previous Message | Adrian Klaver | 2015-10-15 14:26:11 | Re: Installing plpython3u |