I have table as below and I am applying below CrossTab query on it.
select * from crosstab
(
'SELECT dates,skillset, queued
from hlfhrly
order by 1,2') as ct ("dates" date,"skillset" text, "queued" bigint )
However I am getting below error, what I am doing wrong here
ERROR: return and sql tuple descriptions are incompatible
SQL state: 42601
I have table as below and I am applying below CrossTab query on it.
select * from crosstab
(
'SELECT dates,skillset, queued
from hlfhrly
order by 1,2') as ct ("dates" date,"skillset" text, "queued" bigint )
However I am getting below error, what I am doing wrong here
ERROR: return and sql tuple descriptions are incompatible
SQL state: 42601