> 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 > > > > <[EMAIL PROTECTED]> 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/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
