In article <20060726182806(dot)A1188(at)ganymede(dot)hub(dot)org>,
"Marc G. Fournier" <scrappy(at)postgresql(dot)org> writes:
> I need to do:
> NOW() + '2 day'::interval
> where 2 is a variable ...
> if I do:
> NOW() + '? day'::interval
> it, of course, takes the ? as a literal ... so is there some way I can
> do this such that I can do the placeholder?
How about the following?
now() + ? * '1 day'::interval