"Rhys A.D. Stewart" <rhys.stewart@gmail.com> writes:
> 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.
I think you need to change ELSE IF to ELSEIF. As written you need two
END IF lines to match the two independent IFs.
I wonder whether we could get plpgsql's parser to be more helpful about
END-matching errors ... they're certainly easy ones to make.
regards, tom lane