Re: BUG #2785: Exception Issue

["pat hayes" <pkhayeskp(at)hotmail(dot)com>]

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