syntax error in a trigger. can't find it.

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

Responses

Browse pgsql-general by date

  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"