| From: | Terry Lee Tucker <terry(at)chosen-ones(dot)org> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Conversion to 8.3 |
| Date: | 2008-04-04 18:31:08 |
| Message-ID: | 200804041431.09034.terry@chosen-ones.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Greetings:
I am converting our application from 7.4.19 to 8.3.1. In the old scheme of
things, I was generating an interval between two timestamps and evaluating
the interval string in another set of trigger code. I was doing the
following:
IF new.ontime IS NOT NULL AND new.ontime ~* 'ago' THEN
.
.
END IF;
With the new casting rules, this doesn't work. How can I determine if this
on-time value is "ago", that is, the shipment is late?
Thanks for any help you can give...
--
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(at)turbocorp(dot)com
www.turbocorp.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Stark | 2008-04-04 18:52:34 | Re: modules |
| Previous Message | Jeff Wigal (Referee Assistant) | 2008-04-04 17:47:51 | Re: Connection reset by peer / broken pipe |