Matt Magoffin wrote:
> 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?
"CAST (? AS INTERVAL)" should work.
Or use org.postgresql.util.PGInterval:
stmt.setObject(1, new PGInterval("14 days"));
-O