"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