Skip site navigation (1)
Skip section navigation (2)
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?
Peripheral Links
Header And Logo
|
Site Navigation
Crosstab limitation...
- From: "ronald tabada" <rtabada(at)gmail(dot)com>
- To: pgsql-sql(at)postgresql(dot)org
- Subject: Crosstab limitation...
- Date: Sat, 1 Dec 2007 11:47:23 +0800
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?
- Prev by Date: Re: Using schema
- Previous by thread: Using schema
- Indexes: