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 <tgl@sss.pgh.pa.us>
>To: "Patrick Hayes" <pkhayeskp@hotmail.com>
>CC: pgsql-bugs@postgresql.org
>Subject: Re: [BUGS] BUG #2785: Exception Issue Date: Mon, 27 Nov 2006
>22:05:04 -0500
>
>"Patrick Hayes" <pkhayeskp@hotmail.com> 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
