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