Re: Conversion to 8.3

"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