Allen <dba@xxxxxxxxxxx> 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
