Ian Barwick wrote:
> On Mon, 22 Nov 2004 15:12:26 +0100, Patrick Fiche
>
> <patrick.fiche@aqsacom.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/