Greetings!
 
In the help file under date and time functions, I see that intervals can
be specified as "interval '3 hours' ".  In a PgAdmin SQL window, I can
enter "select interval '3 hours' ", and it will return me "03:00:00", as
expected.  I can also enter "select '3 hours'::interval", and get the
same result.  Yet neither syntax works inside a function.  
 
declare
     ThreeHours interval;
begin
     ThreeHours = interval '3 hours';  -- throws a syntax error
     ThreeHours = '3 hours'::interval; -- also throws a syntax error
end;
 
So how do I specify an interval in a function?
 
Specifically, I'm trying to do something like the following:
 
    if NewRevisionTime < PredictedEndTime - '08:00:00'::interval then
 
Since both of the shown forms give syntax errors, how do I subtract
eight hours from a time???
 
Thank you very much.
 
RobR, who posted this on the novice list but got no answers.
 

Reply via email to