Re: Crosstab limitation...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "ronald tabada" <rtabada(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Crosstab limitation...
Date: 2007-12-01 04:07:36
Message-ID: 11003.1196482056@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"ronald tabada" <rtabada(at)gmail(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Joost Kraaijeveld 2007-12-03 05:52:29 alias required by standard or PostgreSQL?
Previous Message ronald tabada 2007-12-01 03:47:23 Crosstab limitation...