I was just tying to perform a crosstab query on pgsql 9.1.4.
I wonder if there is something to know for creating a pivot table by using crosstab when the pivot table has more then ten fields.
I prepared crosstab query that aggregate less than 10 fields correctly whilst another crosstab query which put together more than 10 fields
give me problem:
a field put as sixth field in the query results 17th, or field put as 17 that results 8th....it seems that field over 9th is put as first (in the beginning)
and not as last.
Of course there could be something wrong in my query, here reported: