Re: replacing expresion in plpgsql

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