Re: [SQL] Crosstab limitation...

2007-11-30 Thread Tom Lane
"ronald tabada" <[EMAIL PROTECTED]> writes: > ... 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. Worksforme. Mayb

[SQL] Crosstab limitation...

2007-11-30 Thread ronald tabada
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 ret