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?