help replacing expresion in plpgsql

From: Juan Pablo L <jpablolorenzetti(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: help replacing expresion in plpgsql
Date: 2013-12-15 23:13:54
Message-ID: CABSYDaazbqNu3vQonx4OhU_4wOkzuTN6T=BQceST0RCuDEeUtQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, i have a function that receives a parameter which represents days:

FUNCTION aaa_recharge_account(expdays integer)

i want to add those days to the CURRENT_DATE, but i do not know how to do
it, i have tried several ways to replace that in an expresion like:

newexpdate := CURRENT_TIMESTAMP + interval '$1 days' using expdays;
(newexpdate is declared as timestamp)

and many more but none work, can someone please help me to find out how can
i replace that parameter into an expression that i can add to
CURRENT_TIMESTAMP or any other way that i can accomplish what i need which
is to add that parameter to the current timestamp. thanks!!!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Juan Pablo L 2013-12-15 23:15:50 replacing expresion in plpgsql
Previous Message David Johnston 2013-12-15 22:09:11 Re: SELECT from record-returning function causes function code to be executed multiple times