I have a function and I want to update a table's two rows but having problem 
with plpgsql & date-time functions. First field of the table must be now() 
this is ok.. but the second field must be now() + '60 days' if the query 
like this : SELECT INTO to_day now() + interval '60 days' ; it works but if 
I use variable instead of  '60 days' it doesn't work. And I must use 
variable....

Thanks



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to