0

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

enter image description here

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

jarlh
  • 42,561
  • 8
  • 45
  • 63

0 Answers0