| 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: | Whole Thread | Raw Message | 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!!!
| 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 |