Re: Conversion to 8.3

"Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)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