Received: from localhost (unknown [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id 5E16E2E3DC7
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 30 Nov 2007 23:47:32 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 95483-06 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 30 Nov 2007 23:47:19 -0400 (AST)
Received: from wr-out-0506.google.com (wr-out-0506.google.com
 [64.233.184.239])
	by postgresql.org (Postfix) with ESMTP id C9CA12E3D98
	for <pgsql-sql@postgresql.org>; Fri, 30 Nov 2007 23:47:25 -0400 (AST)
Received: by wr-out-0506.google.com with SMTP id 58so2210048wri
	for <pgsql-sql@postgresql.org>; Fri, 30 Nov 2007 19:47:24 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type;
	bh=dqHWZs9MMQYrnoJTIoK+/7Z0Adn/JcsOaTOi8U9qohs=;
	b=rtKT8esoghiKRP/iCJKwPQCpDZzxi2g4TQMkTFUMZt+0XmN7zEChdLgsoKU+IRAM9aW+8Kk3Apo2aFY9H4DcBZteKEBR/mH15FCqJgaEW/V9W6FXYRz9ccpQtOUgmK1Xyt2LXinXynjPe+E5XbthvRwpwQi0zVWTGLQ0chsRWQk=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=si5+Ay+6YUutCN9Fca4XBoEVpkSu8nQHeBW7UIuU9jNK3Kh5Y9zm3FkjnKPTC+e//pnfaX0BB0s+qMTudUGghr9vyaLQUA4ySTo29ChODHfzx16mR/6Zts7UPM2XkdUBD650yfM+oyzxgwi1SsMPcQxLs1f2zOzgrrfp97RWiZE=
Received: by 10.70.22.15 with SMTP id 15mr2170131wxv.1196480843186;
	Fri, 30 Nov 2007 19:47:23 -0800 (PST)
Received: by 10.90.27.17 with HTTP; Fri, 30 Nov 2007 19:47:23 -0800 (PST)
Message-ID: <29b0500c0711301947w312866d0i27139c6b759b88bf@mail.gmail.com>
Date: Sat, 1 Dec 2007 11:47:23 +0800
From: "ronald tabada" <rtabada@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Crosstab limitation...
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_6157_7213452.1196480843174"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200711/164
X-Sequence-Number: 29692

------=_Part_6157_7213452.1196480843174
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Good day... I'm new in postgresql and I used PostgreSQL 8.2. I tried
generating a query that can convert 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.

Can anyone help me? How can I use crosstab w/ more than 17 columns?

------=_Part_6157_7213452.1196480843174
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Good day... I&#39;m new in postgresql and I used PostgreSQL 8.2. I tried<br>generating a query that can convert rows into columns. I was<br>happy when I discovered the crosstab function. But when I tried<br>producing reports with more than 17 columns it displayed the following
<br>error message:<br><br>ERROR: invalid return type<br>SQL state: 42601<br>Detail: Query-specified return tuple has 39 columns but crosstab returns 17.<br><br>Can anyone help me? How can I use crosstab w/ more than 17 columns?
<br>

------=_Part_6157_7213452.1196480843174--