On Mon, 10 Nov 2003, Kumar wrote:
> select now()+ interval'1 month'; -- This is working fine.
>
> I wanna dynamically assign the interval number. i,e --> select now()+
> interval'n month';
If n is an integer, I'd suggest something like
select now() + n * interval '1 month';
rather than messing around with the text of the interval literal.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
