From: | amr(dot)fadly(at)vodafone(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #14024: problem in Creating pivot table |
Date: | 2016-03-16 13:56:57 |
Message-ID: | 20160316135657.5232.46379@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14024
Logged by: AmrFadly
Email address: amr(dot)fadly(at)vodafone(dot)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
);
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2016-03-16 14:02:38 | to_char(OF) is broken |
Previous Message | Teodor Sigaev | 2016-03-16 13:52:31 | Re: BUG #13440: unaccent does not remove all diacritics |