Re: convert integer to interval ?

pilsl@goldfisch.at wrote:
> Sorry, I dont get familar with timefunctions in 7.3.2.  I just
> upgraded and I need a function that adds a given interval in days to a
> given timestamp.
>
> something like
> select current_timestamp+interval '7 days';
>
> in my table the 7 is given as integer. And I dont get the conversion
> from this integer to interval where the integernumber is in days.

Is there any reason why you can't do:

sprintf(buf,"select current_timestamp+interval '%d days'",int_days);

Magnus