Re: Perl::DBI and interval syntax

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.

            regards, tom lane