The following bug has been logged on the website:
Bug reference: 14024
Logged by: AmrFadly
Email address: amr.fadly@vodafone.com
PostgreSQL version: 9.5.0
Operating system: Windows 7
Description:
we are trying to do the example in the documentation to create pivot table
using crosstab function, it is not working and gives the below error:
ERROR: function crosstab(unknown, unknown) does not exist
SQL state: 42883
Hint: No function matches the given name and argument types. You might need
to add explicit type casts.
Character: 15
the example is:
CREATE TABLE cth(rowid text, rowdt timestamp, attribute text, val text);
INSERT INTO cth VALUES('test1','01 March 2003','temperature','42');
INSERT INTO cth VALUES('test1','01 March 2003','test_result','PASS');
INSERT INTO cth VALUES('test1','01 March 2003','volts','2.6987');
INSERT INTO cth VALUES('test2','02 March 2003','temperature','53');
INSERT INTO cth VALUES('test2','02 March 2003','test_result','FAIL');
INSERT INTO cth VALUES('test2','02 March 2003','test_startdate','01 March
2003');
INSERT INTO cth VALUES('test2','02 March 2003','volts','3.1234');
SELECT * FROM crosstab('SELECT rowid, rowdt, attribute, val FROM cth ORDER
BY 1','SELECT DISTINCT attribute FROM cth ORDER BY 1')
AS
(
rowid text,
rowdt timestamp,
temperature int4,
test_result text,
test_startdate timestamp,
volts float8
);