Re: Help with syntax for timestamp addition - Mailing list pgsql-general

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;

Ian Barwick