"Patrick Hayes" <[EMAIL PROTECTED]> writes:
> I get the following error.
> postgres-# language plpgsql;
> ERROR: unrecognized exception condition "no_data"
> CONTEXT: compile of PL/pgSQL function "chip_pps_data_check" near line 101
Indeed, because no_data is not an error condition, so EXCEPTION can't
catch it. Possibly you could do something with testing the FOUND
variable instead.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend