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
On Friday 04 April 2008 16:36, Tom Lane wrote:
> Terry Lee Tucker <[EMAIL PROTECTED]> writes:
> > 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 trigg
"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:
re
On Fri, Apr 4, 2008 at 2:39 PM, Terry Lee Tucker <[EMAIL PROTECTED]> wrote:
> On Friday 04 April 2008 15:01, Craig Ringer wrote:
>
> > Terry Lee Tucker wrote:
> > > Greetings:
> > >
> > > I am converting our application from 7.4.19 to 8.3.1. In the old scheme
> > > of things, I was generating a
On Friday 04 April 2008 16:36, Tom Lane wrote:
> Terry Lee Tucker <[EMAIL PROTECTED]> writes:
> > 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 trigg
On Friday 04 April 2008 15:01, Craig Ringer wrote:
> Terry Lee Tucker wrote:
> > 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 tri
Terry Lee Tucker <[EMAIL PROTECTED]> writes:
> 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.ontim
Terry Lee Tucker wrote:
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 AN
