Sumita Biswas wrote:
Hi Experts,
I try to write the following in my Function and it works:
ld_FromDateTemp := ld_FromDate + ''5 DAYS''::interval;
But when I have to pass a parameter in the NUMBER of days(instead of 5)
like 'li_NoOfDays'
ld_FromDateTemp := ld_FromDate + ''li_NoOfDays DAYS''::interval;
You want ... + (li_NoOfDays || '' DAYS'')::interval;
plpgsql doesn't interpolate variables like perl/php do.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly