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  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: BUG #14024: problem in Creating pivot table  (Joe Conway <mail@joeconway.com>)
Список 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 по дате отправления:

Предыдущее
От: Dmitriy Sarafannikov
Дата:
Сообщение: Re: Too many files in pg_replslot folder
Следующее
От: carlos_penteado@yahoo.com.br
Дата:
Сообщение: BUG #14026: Problem to convert number to real