Tom,
Thank you for your input. I found a way to check for it by counting the
return from a count. Thanks again for your help.
PAT
From: Tom Lane <[EMAIL PROTECTED]>
To: "Patrick Hayes" <[EMAIL PROTECTED]>
CC: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #2785: Exception Issue Date: Mon, 27 Nov 2006
22:05:04 -0500
"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
_________________________________________________________________
MSN Shopping has everything on your holiday list. Get expert picks by style,
age, and price. Try it!
http://shopping.msn.com/content/shp/?ctId=8000,ptnrid=176,ptnrdata=200601&tcode=wlmtagline
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend