Re: replacing expresion in plpgsql

Hi, thank you very much, this worked flawlessly, this is the final code:

execute 'select CURRENT_TIMESTAMP + $1 * interval ''1 day''' into
newexpdate using expdays;

works perfect, thanks a ton!

On 15 December 2013 18:23, John R Pierce <pierce(at)hogranch(dot)com> wrote:

> 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, current_timestamp + $1 * interval '1 day';
>
> note this will work with values in hours, months, any unit, really.
>
>
> --
> john r pierce 37N 122W
> somewhere on the middle of the left coast
>
>
>
> --
> 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
>