Conversion to 8.3

Поиск
Список
Период
Сортировка
От Terry Lee Tucker
Тема Conversion to 8.3
Дата
Msg-id 200804041431.09034.terry@chosen-ones.org
обсуждение исходный текст
Ответы Re: Conversion to 8.3
Re: Conversion to 8.3
Список 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@turbocorp.com
www.turbocorp.com

В списке pgsql-general по дате отправления:

Предыдущее
От: mark
Дата:
Сообщение: Re: simple update queries take a long time - postgres 8.3.1
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: how to insert values into complex type field