Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id 922CE9FB958
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 25 Jun 2007 16:56:02 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 37518-01 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 25 Jun 2007 16:55:55 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from pyxis.powervt.com.ar (host6.powervt.com.ar [200.43.63.66])
	by postgresql.org (Postfix) with ESMTP id F21BA9FB2B1
	for <pgsql-sql@postgresql.org>; Mon, 25 Jun 2007 16:55:57 -0300 (ADT)
Received: from pcfhevia ([201.216.249.98])
	by pyxis.powervt.com.ar (IPGroup Mail Server) with ESMTP id 1OT48953;
	Mon, 25 Jun 2007 16:55:57 -0300
From: "Fernando Hevia" <fhevia@ip-tel.com.ar>
To: "'Andrew Sullivan'" <ajs@crankycanuck.ca>,
	<pgsql-sql@postgresql.org>
Subject: Re: NO DATA FOUND Exception
Date: Mon, 25 Jun 2007 16:55:58 -0300
Organization: IP-TEL
Message-ID: <04ed01c7b762$da216c50$8f01010a@iptel.com.ar>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook 11
In-Reply-To: <20070625193521.GI19717@phlogiston.dyndns.org>
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
Thread-Index: Ace3YBRhOenuGoXeSZO9Dhk5PPG9awAAg2Xw
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200706/207
X-Sequence-Number: 28697


>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.