Category "crosstab"

CROSSTAB PostgreSQL - Alternative for PIVOT in Oracle

I'm migrating a query of Oracle pivot to PostgreSQL crosstab. create table(cntry numeric,week numeric,year numeric,days text,day text); insert into x_c values(