"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

Reply via email to