On Saturday 05 April 2008 11:21, Tom Lane wrote: > "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 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 terry@xxxxxxxxxxxxx www.turbocorp.com
