Re: Perl::DBI and interval syntax

On Mon, Nov 07, 2005 at 05:58:04PM -0500, Tom Lane wrote:
> Allen <dba@girders.org> writes:
> > SELECT count(*) from post where post_ts >= current_date - interval ?
>
> This is not right, and never has been right, even though it may have
> accidentally failed to fail with some client libraries.  Try
>     CAST(? as interval)            (SQL standard)
>     ?::interval                (Postgres-ism)
>
> The "interval something" syntax is only legal when "something" is
> a bare string literal.

This seems to be an example of breakage caused by DBI switching from
"substitute params in client" to "use new protocol to substitute params
in server" (prepare/execute).

AIUI, if you disable use of the new protocol, it should work as before.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.