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 8: explain analyze is your friend
