Re: replacing expresion in plpgsql

thank you very much for clarifying .....

On 15 December 2013 19:02, Andreas Brandl <ml(at)3(dot)141592654(dot)de> wrote:

> John,
>
> ----- Ursprüngliche Mail -----
> > On 12/15/2013 4:17 PM, Andreas Brandl wrote:
> > > select current_timestamp, current_timestamp + interval '2' day;
> >
> > that should be interval '2 day' (note the ' moved), and for a
> > variable number passed as a parameter, try...
>
> # select current_timestamp + interval '2' day;
> # select current_timestamp + interval '2' minute;
>
> all valid, but seems to only work in SQL (and not plpgsql) context.
>
> Regards,
> Andreas
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>