Good day... I'm new in postgresql and I used PostgreSQL 8.2. I tried generating a query that can convert your 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. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
