Allen <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
