Re: Help with prepared statment for crosstab - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Help with prepared statment for crosstab
Date
Msg-id alpine.BSO.2.00.0911031317580.29390@leary.csoft.net
Whole thread Raw
In response to Help with prepared statment for crosstab  (Carl Shelbourne <Carl.Shelbourne@stanleybet.com>)
List pgsql-jdbc

On Tue, 3 Nov 2009, Carl Shelbourne wrote:

> The SQL shown below works if I do not have any parameters, but when I add
> the parameters, I get:
>
> Caused by: org.postgresql.util.PSQLException: The column index is out of ra
> nge: 1, number of columns: 0. 

The ? parameters you've used are inside a string literal, so they are not
considered parameters.  Consider:

SELECT 'Does this work?';

The question mark is part of the literal, not a parameter.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Bug - DatabaseMetaData.getCatalogs() was [Novice] Can't get list of databases with \list
Next
From: Michael Wood
Date:
Subject: Re: [NOVICE] Bug - DatabaseMetaData.getCatalogs() was [Novice] Can't get list of databases with \list