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@xxxxxxxxxxx> 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 > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
