Dear Sirs:
Please I need to construct a stored procedure with pl/pgsql ,
I need execute the query:
update expire_date=now+'expire_time seconds';
where expire_time is a variable , then I need to replace this
at the SP, but I attempted write like as:
update expire_date=now+''expire_time seconds''
but this expresion apparently is replaced as:
update expire_date=now+'expire_time seconds'
i.e this places the string expire_time but I need the
variable expire_time,
How I can to perform it?
Thank you.
I hopee your help, thank you in advance
Ernesto Freyre