Postgres Pro
Downloads
Home   >   mailing lists

Re: replacing expresion in plpgsql - Mailing list pgsql-general

From Juan Pablo L
Subject Re: replacing expresion in plpgsql
Date
Msg-id CABSYDaZdDg5hgJ=VbMHhfK3tcL8enFbKf5Noob++SqyiuVuN4A@mail.gmail.com
Whole thread Raw
In response to Re: replacing expresion in plpgsql  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view
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@hogranch.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Juan Pablo L
Date:
Subject: Re: replacing expresion in plpgsql
Next
From: Andreas Brandl
Date:
Subject: Re: replacing expresion in plpgsql