BUG #14024: problem in Creating pivot table
От | amr.fadly@vodafone.com |
---|---|
Тема | BUG #14024: problem in Creating pivot table |
Дата | |
Msg-id | 20160316135657.5232.46379@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #14024: problem in Creating pivot table
Re: BUG #14024: problem in Creating pivot table |
Список | pgsql-bugs |
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 );
В списке pgsql-bugs по дате отправления: