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