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@