我正在尝试在Postgres 10中使用"交叉表"函数,它给我抛出了以下错误,我不明白为什么:
错误:返回和 SQL 元组描述不兼容SQL 状态:42601
select * from crosstab
($$select xx, xxy, sum(t) as lala from po.zBORRARvi_intermedia
group by xx, xxy order by 1,2$$) as
ct("xx" varchar(255), "xy1" double precision, "xy2" double precision, "xy3" double precision,
"xy4" double precision,"xy5" double precision, "xy6" double precision, "xy7" double precision,
"xy8" double precision);
必须
根据预期的列数正确定义交叉表的返回类型。
请阅读此链接