Date addition using Interval - Mailing list pgsql-general

From Sumita Biswas
Subject Date addition using Interval
Date
Msg-id 023701c4315a$32c55f70$dc656540@amer.cisco.com
Whole thread Raw
In response to Re: Postgres DB  (Kris Jurka <books@ejurka.com>)
Responses Re: Date addition using Interval  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Re: Date addition using Interval  (Richard Huxton <dev@archonet.com>)
List pgsql-general
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;

Does not work. Error as follows:
------------------------------------------------------------------------
--------
WARNING:  Error occurred while executing PL/pgSQL function
proc_dailyutilization
WARNING:  line 41 at assignment
ERROR:  Bad interval external representation 'li_NoOfDays DAYS'
------------------------------------------------------------------------
--------
If I write this way:
ld_FromDateTemp := ld_FromDate +  li_NoOfDays ''DAYS''::interval;

Following Error:
------------------------------------------------------------------------
--------
WARNING:  Error occurred while executing PL/pgSQL function
proc_dailyutilization
WARNING:  line 41 at assignment
ERROR:  parser: parse error at or near "'DAYS'" at character 21
------------------------------------------------------------------------
--------


I am sure there is a way of doing it. Can anyone point out where I am
going wrong?

Thanks in Advance.

Regards,
Sumita




pgsql-general by date:

Previous
From: "Sally Sally"
Date:
Subject: postgres mirroring (real-time)
Next
From: Tom Lane
Date:
Subject: Re: vacuumdb is failing with NUMBER OF INDEX TUPLES NOT THE SAME AS HEAP