INTERVAL parameter in PreparedStatement worked in 7.4 but not in 8.0 driver

From: "Matt Magoffin" <postgresql(dot)org(at)msqr(dot)us>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: INTERVAL parameter in PreparedStatement worked in 7.4 but not in 8.0 driver
Date: 2005-10-27 23:56:05
Message-ID: 50387.219.89.94.58.1130457365.squirrel@msqr.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello,

I used to use the following style statement with the 7.4 series JDBC driver:

select * from users users where users.createdDate < (CURRENT_DATE -
INTERVAL ?)

and would set the parameter to a string value of "14 DAYS"

but in the Postgres 8 driver, this query executes but does not seem to
ever return anything. Is there a better syntax I could use to make this
work?

The query does work in the 8 driver if the ? is explicitly part of the
query, i.e. not a positional parameter, like this:

select * from users users where users.createdDate < (CURRENT_DATE -
INTERVAL '14 DAYS')

Any help much appreciated,
m@

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Matt Magoffin 2005-10-28 00:02:14 Re: INTERVAL parameter in PreparedStatement worked in 7.4
Previous Message Heikki Linnakangas 2005-10-27 15:24:36 Re: XADataSource interface