Thanks Richard, It works fine now. Regards, Sumita -----Original Message----- From: Richard Huxton [mailto:dev@archonet.com] Sent: Wednesday, May 05, 2004 9:18 AM To: Sumita Biswas Cc: 'Kris Jurka'; 'Tom Lane'; pgsql-general@postgresql.org Subject: Re: Date addition using Interval 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 6: Have you searched our list archives? http://archives.postgresql.org
