setting PreparedStatement parameter using "at time zone interval ?" - Mailing list pgsql-jdbc

From Matt Magoffin
Subject setting PreparedStatement parameter using "at time zone interval ?"
Date
Msg-id 55255.192.168.1.108.1198055905.squirrel@msqr.us
Whole thread Raw
Responses Re: setting PreparedStatement parameter using "at time zone interval ?"  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-jdbc
I'm using the latest 8.3 development driver against an 8.3 database. I
thought back in 8.1 I used to be able to use a PreparedStatement that
included something like

... date(l.created AT TIME ZONE INTERVAL ?)

but now I am always getting an exception like

org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1"

I found if I changed the query to use this syntax:

... date(timezone(?::interval, l.created))

it worked fine. Should the former syntax be supported by the JDBC driver?

-- m@

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Patch for Statement.getGeneratedKeys()
Next
From: Daniel Migowski
Date:
Subject: TypeInfoCache