pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Crosstab limitation... 2+ messages / 2 participants [nested] [flat]
* Crosstab limitation... @ 2007-12-01 03:47 ronald tabada <rtabada@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: ronald tabada @ 2007-12-01 03:47 UTC (permalink / raw) To: pgsql-sql 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? ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Crosstab limitation... @ 2007-12-01 04:07 Tom Lane <tgl@sss.pgh.pa.us> parent: ronald tabada <rtabada@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2007-12-01 04:07 UTC (permalink / raw) To: ronald tabada <rtabada@gmail.com>; +Cc: 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-12-01 04:07 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2007-12-01 03:47 Crosstab limitation... ronald tabada <rtabada@gmail.com> 2007-12-01 04:07 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox