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