From: | Scott Nixon <snixon(at)lssi(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Help with syntax for timestamp addition |
Date: | 2004-11-22 15:33:29 |
Message-ID: | 1101137609.23458.16.camel@talon |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> Just to add to the record, the mathematically sound way to write this
> query would be this:
>
> SELECT number
> FROM procedures
> WHERE date + numdays * interval '1 day' <= current_timestamp;
Thanks for that Peter! That's a lot closer than what I originally
had...I didn't think about doing that but it makes sense.
Is there any advantage/disadvantages to using this method or the other?
On Mon, 2004-11-22 at 10:26, Peter Eisentraut wrote:
> Ian Barwick wrote:
> > On Mon, 22 Nov 2004 15:12:26 +0100, Patrick Fiche
> >
> > <patrick(dot)fiche(at)aqsacom(dot)com> wrote:
> > > Have a try at this syntax
> > >
> > > SELECT number
> > > FROM procedures
> > > WHERE date + CAST( numdays || ' days' AS interval ) <=
> > > CURRENT_TIMESTAMP;
> >
> > Just for the record you could write it like this too:
> > SELECT number
> > FROM procedures
> > WHERE date + (numdays || ' days')::interval <= CURRENT_TIMESTAMP;
>
> Just to add to the record, the mathematically sound way to write this
> query would be this:
>
> SELECT number
> FROM procedures
> WHERE date + numdays * interval '1 day' <= current_timestamp;
>
> --
> Peter Eisentraut
> http://developer.postgresql.org/~petere/
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-11-22 15:52:59 | Re: Wrong string length from unicode database in Borland's app |
Previous Message | Peter Eisentraut | 2004-11-22 15:26:55 | Re: Help with syntax for timestamp addition |