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

Have you installed the tablefunc extension？
please show the \dx results in psql?

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

2013/8/19 <pradeep(dot)v(dot)prade(at)gmail(dot)com>

> The following bug has been logged on the website:
>
> Bug reference: 8386
> Logged by: pradeep v
> Email address: pradeep(dot)v(dot)prade(at)gmail(dot)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?
>
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>