Crosstab limitation... - Mailing list pgsql-general

From ronald tabada
Subject Crosstab limitation...
Date
Msg-id 29b0500c0711280617w5a15d9f6s12f65cbc907e83bc@mail.gmail.com
Whole thread Raw
List pgsql-general
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.

pgsql-general by date:

Previous
From: Glyn Astill
Date:
Subject: Error compiling Slony I
Next
From: Scott Ribe
Date:
Subject: Re: Linux v.s. Mac OS-X Performance