Re: [GENERAL] How can I use crosstab functons in PostgreSQL 9.3?

: Thursday, October 15, 2015 10:31 AM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] How can I use crosstab functons in PostgreSQL 9.3? Looks to me like argument types possibly? The article creates various combinations of crosstab() function but you are passing in a query. Wrap y

Re: [GENERAL] How can I use crosstab functons in PostgreSQL 9.3?

On Thu, Oct 15, 2015 at 10:48 AM, Rob Richardson wrote: > By George, I think I've got it! > > When I ran CREATE EXTENSION tablefunc WITH SCHEMA public, I got the > crosstab methods and my sample query worked. > I would suggest learning about search_path(s) instead of

[GENERAL] How can I use crosstab functons in PostgreSQL 9.3?

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. For example, I am trying to run the

Re: [GENERAL] How can I use crosstab functons in PostgreSQL 9.3?

Rob Richardson 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

Re: [GENERAL] How can I use crosstab functons in PostgreSQL 9.3?

I should have mentioned (twice now) that I'm running under Windows 7. RobR -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Thursday, October 15, 2015 10:19 AM To: Rob Richardson Cc: pgsql-general General Subject: Re: [GENERAL] How can I use crosstab functons

Re: [GENERAL] How can I use crosstab functons in PostgreSQL 9.3?

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

Re: [GENERAL] How can I use crosstab functons in PostgreSQL 9.3?

By George, I think I've got it! When I ran CREATE EXTENSION tablefunc WITH SCHEMA public, I got the crosstab methods and my sample query worked. RobR -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: