Allen <dba(at)girders(dot)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