Reply-To: <nickf@ontko.com>
From: "Nick Fankhauser" <nickf@ontko.com>
To: "helen liu" <helengliu@yahoo.com>, <pgsql-admin@postgresql.org>
Subject: Re: query problem
Date: Mon, 13 Jan 2003 16:47:22 -0500
Message-ID: <NEBBLAAHGLEEPCGOBHDGGEAMGIAA.nickf@ontko.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Importance: Normal
In-Reply-To: <20030113164401.30080.qmail@web14602.mail.yahoo.com>

Helen-

There is a separate JDBC list for related questions that I suggest you use
in the future.

A code sample is needed for a really good answer, but I'll make a guess.
This message is probably telling you that you are either trying to set a
value in a where clause that has a higher index than the number you
prepared. (eg: you have two columns constrained and tried to set a third.)
Or, you are trying to read a column from the resultset that has a higher
index than those you defined when preparing the statement. (eg: your query
returns two fields and you're asking for a third.)

Your SQL statement may look fine, but you're either setting or getting
something that it doesn't have.

-Nick


-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]On Behalf Of helen liu
Sent: Monday, January 13, 2003 11:44 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] query probelm


Hello,
I am new in postgresql. sorry if I may ask simple question. I got error
message when I pass sql statement into database through JDBC. the error msg
is:
"connect and execute query: The column index is out of range."
I check the sql statement string passed into db, it looks fine. I have no
idea what is going wrong. any help is highly appreciated.
Helen


Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now