setting PreparedStatement parameter using "at time zone interval ?"
От
Matt Magoffin
Тема
setting PreparedStatement parameter using "at time zone interval ?"
Дата
Msg-id
55255.192.168.1.108.1198055905.squirrel@msqr.us
Список
Дерево обсуждения
setting PreparedStatement parameter using "at time zone interval ?" "Matt Magoffin" <postgresql.org@msqr.us>
Re: setting PreparedStatement parameter using "at time zone interval ?" Tom Lane <tgl@sss.pgh.pa.us>
Re: setting PreparedStatement parameter using "at time zone
interval ?" "Matt Magoffin" <postgresql.org@msqr.us>
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 по дате отправления