"Scott Marlowe" <scott.marlowe@gmail.com> 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