Re: Dynamic Query for System functions - now()

Kumar wrote:

> Dear Friends,
>
> I am using PostgreSQL 7.3.4 Server on RH Linux 7.2. I am trying to
> generate a dynamic query to fetch the next month interval.
>
> select now()+ interval'1 month'; -- This is working fine.
>
> I wanna dynamically assign the interval number. i,e --> select now()+
> interval'n month';

What about:

select now() + n * '1 month'::intervall;

Regards
Gaetano Mendola