Re: Date addition using Interval - Mailing list pgsql-general

From Sumita Biswas
Subject Re: Date addition using Interval
Date
Msg-id 041701c43304$1c848870$dc656540@amer.cisco.com
Whole thread Raw
In response to Re: Date addition using Interval  (Richard Huxton <dev@archonet.com>)
List pgsql-general
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: [GENERAL] 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


pgsql-general by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: pgFoundry Open For Business
Next
From: Razvan Surdulescu
Date:
Subject: Re: Cache lookup failure for pg_restore?