Postgres Pro
Downloads
Home   >   mailing lists

Thread: BUG #8386: function crosstab(unknown) does not exist

BUG #8386: function crosstab(unknown) does not exist

From
pradeep.v.prade@gmail.com
Date:
The following bug has been logged on the website:

Bug reference:      8386
Logged by:          pradeep v
Email address:      pradeep.v.prade@gmail.com
PostgreSQL version: 9.2.1
Operating system:   windows 7
Description:

when i execute query
 SELECT * FROM crosstab(
       'SELECT section, status, count
        FROM   t
        ORDER  BY 1,2')
AS ct ("Section" text, "Active" text, "Inactive" int);




the "function crosstab(unknown) does not exist" error comes may i know why?

Re: BUG #8386: function crosstab(unknown) does not exist

From
Jov
Date:
Have you installed the tablefunc extension=EF=BC=9F
please show the \dx results in psql?



Jov
blog: http:amutu.com/blog <http://amutu.com/blog>


2013/8/19 <pradeep.v.prade@gmail.com>

> The following bug has been logged on the website:
>
> Bug reference:      8386
> Logged by:          pradeep v
> Email address:      pradeep.v.prade@gmail.com
> PostgreSQL version: 9.2.1
> Operating system:   windows 7
> Description:
>
> when i execute query
>  SELECT * FROM crosstab(
>        'SELECT section, status, count
>         FROM   t
>         ORDER  BY 1,2')
> AS ct ("Section" text, "Active" text, "Inactive" int);
>
>
>
>
> the "function crosstab(unknown) does not exist" error comes may i know wh=
y?
>
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>