"Scott Marlowe" <scott.marlowe@xxxxxxxxx> writes: > what type is new.ontime ?? timestamp or interval. I would expect it > to be an interval. But intervals are either negative or positive, not > "ago" unless that's something peculiar to 7.4 that I've long since > forgotten. No, it's still around: regression=# select '-1 day'::interval; interval ---------- -1 days (1 row) regression=# set datestyle = postgres; SET regression=# select '-1 day'::interval; interval ------------- @ 1 day ago (1 row) The most bletcherous aspect of Terry's original coding is that it fails entirely, and silently, if the DateStyle setting isn't what it's assuming... regards, tom lane
