Does any one know how to create crosstab queries in PostgreSQL?
For example I have the following table:
Section Status Count A Active 1 A Inactive 2 B Active 4 B Inactive 5
I would like the query to return the following crosstab:
Section Active Inactive A 1 2 B 4 5
Is this possible?