Postgres Pro
Downloads
Home   >   mailing lists

syntax error in a trigger. can't find it. - Mailing list pgsql-general

From Rhys A.D. Stewart
Subject syntax error in a trigger. can't find it.
Date
Msg-id CACg0vTmbf4SJy3sLjaWTVvKQv+oo8kVqppPFF4o2QvJqrcQvpw@mail.gmail.com
Whole thread Raw
Responses Re: syntax error in a trigger. can't find it.  ("Rhys A.D. Stewart" <rhys.stewart@gmail.com>)
Re: syntax error in a trigger. can't find it.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: changes "during checkpointing"
Next
From: "Rhys A.D. Stewart"
Date:
Subject: Re: syntax error in a trigger. can't find it.