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

Found it, had ELSE IF instead of elsif......very from the indicated error.

On Sat, Jan 12, 2013 at 5:10 PM, Rhys A.D. Stewart
<rhys(dot)stewart(at)gmail(dot)com>wrote:

> 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
>