Re: interval +variable

+ '1 days'::interval

""Fatih Cerit"" <fatih@intersan.com.tr>, haber iletisinde �unlar� 
yazd�:008a01c52486$1c1c9520$bb41ccd5@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
>