On Saturday 05 April 2008 11:21, Tom Lane wrote:
> "Scott Marlowe" <[EMAIL PROTECTED]> 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

Well, I didn't realize that "ago" was only applicable to a certain date style 
setting. I don't recall ever reading that anywhere but maybe I missed it. Now 
I know how to do it correctly.

Thanks to all who responded...
-- 
Terry Lee Tucker
Turbo's IT Manager
Turbo, division of Ozburn-Hessey Logistics
2251 Jesse Jewell Pkwy NE
Gainesville, GA 30501
Tel: (336) 372-6812  Fax: (336) 372-6812  Cell: (336) 404-6987
[EMAIL PROTECTED]
www.turbocorp.com

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to