Re: setting PreparedStatement parameter using "at time zone interval ?"

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

"Matt Magoffin" <postgresql(dot)org(at)msqr(dot)us> writes:
> 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 ?)

That might've worked back before the driver did real prepared
statements.  It's invalid syntax though, because typename before the
constant works only for simple literal string constants.  You got away
with it when the driver interpolated parameter values into the query as
string literals, but you can't do it anymore.

?::interval (or the full-blown CAST syntax) is the right way.

See
http://developer.postgresql.org/pgdocs/postgres/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS
particularly 4.1.2.5.

			regards, tom lane