Re: NO DATA FOUND Exception - Mailing list pgsql-sql

From Fernando Hevia
Subject Re: NO DATA FOUND Exception
Date
Msg-id 04ed01c7b762$da216c50$8f01010a@iptel.com.ar
Whole thread Raw
In response to Re: NO DATA FOUND Exception  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-sql
>On Mon, Jun 25, 2007 at 04:20:37PM -0300, Fernando Hevia wrote:
>>   when <<data_found>> then return variable;
>>   when <<no_data_found>> then <<do nothing/continue>> ;
>>   when <<any_other_exception>> then <<raise some error message>> ;
>
>Check out the FOUND variable in the documentation for the first two,
>and the "trapping errors" section for the latter.
>
>Andrew Sullivan  | ajs@crankycanuck.ca

Thanks for the tip. I was looking in the wrong place.
The FOUND variable is explained in chapter "37.6.6. Obtaining the Result
Status".

Thanks again,
Fernando.





pgsql-sql by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: NO DATA FOUND Exception
Next
From: Michael Glaesemann
Date:
Subject: Re: NO DATA FOUND Exception