"ronald tabada" <rtabada@gmail.com> 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. Maybe you need to show us exactly what you did. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate