Re: BUG #2785: Exception Issue

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