Re: Crosstab limitation... - Mailing list pgsql-sql

From Tom Lane
Subject Re: Crosstab limitation...
Date
Msg-id 11003.1196482056@sss.pgh.pa.us
Whole thread Raw
In response to Crosstab limitation...  ("ronald tabada" <rtabada@gmail.com>)
List pgsql-sql
"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


pgsql-sql by date:

Previous
From: "ronald tabada"
Date:
Subject: Crosstab limitation...
Next
From: "Joost Kraaijeveld"
Date:
Subject: alias required by standard or PostgreSQL?