From: | "Rhys A(dot)D(dot) Stewart" <rhys(dot)stewart(at)gmail(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | syntax error in a trigger. can't find it. |
Date: | 2013-01-12 22:10:12 |
Message-ID: | CACg0vTmbf4SJy3sLjaWTVvKQv+oo8kVqppPFF4o2QvJqrcQvpw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Greetings,
I must be very tired, very hungry or both. I'm getting a syntax error in
the last line with the 'END;' But am clearly not seeing what the error is.
Any help would be appreciated.
________________________________________
create or replace function dev.rqst_insrt()
returns trigger as
$_$
DECLARE
lrec record;
BEGIN
select into lrec * from dev.rqst where rqst_delivery_time order by
rqst_delivery_time desc limit 1;
if (lrec.rqst_delivery_time + '2.5 hours'::interval)::time > '16:40'::time
AND extract('dow' from (lrec.rqst_delivery_time + '24 hours'::interval))
in (1,2,3,4,5) THEN
NEW.rqst_delivery_time := now() + '20 hours';
ELSE IF (lrec.rqst_delivery_time + '2.5 hours'::interval)::time >
'16:40'::time AND extract('dow' from (lrec.rqst_delivery_time + '24
hours'::interval)) in (0,6) THEN
NEW.rqst_delivery_time := now() + '2 days';
END if;
RETURN NEW;
END;
$_$
language plpgsql
____________________________________________
Regards,
Rhys
Peace & Love|Live Long & Posper
From | Date | Subject | |
---|---|---|---|
Next Message | Rhys A.D. Stewart | 2013-01-12 22:28:32 | Re: syntax error in a trigger. can't find it. |
Previous Message | Jeff Janes | 2013-01-12 21:02:27 | Re: changes "during checkpointing" |