Good day... I'm new in postgresql and I used PostgreSQL 8.2. I tried generating a query that can convert rows into columns. I was happy when I discovered the crosstab function. But when I tried producing reports with more than 17 columns it displayed the following error message:
ERROR: invalid return type SQL state: 42601 Detail: Query-specified return tuple has 39 columns but crosstab returns 17. Can anyone help me? How can I use crosstab w/ more than 17 columns?
