[SQL] interval +variable

[Fatih Cerit]

Dear all
Is there anyone at there who knows howto use dateadd in pgsql. I have a 
problem in my function that is like this ;

Select into futuredate now() + interval '30 days';  <- this is ok
but how can I use a variable intead of '30 days'    :(
Thanks 

---------------------------(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