"James B. Byrne" <byrnejb@harte-lyne.ca> writes:
> I just need another set of eyes to see whatever it is that I am
> overlooking.
The RETURN is inside the EXCEPTION clause.
You really need two BEGINs here, one for the outer function body and
one for the exception block around the INSERT.
regards, tom lane