Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id B89219FBAB0
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 25 Jun 2007 16:35:31 -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 73724-05 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 25 Jun 2007 16:35:25 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140])
	by postgresql.org (Postfix) with ESMTP id 1B3129FB8E8
	for <pgsql-sql@postgresql.org>; Mon, 25 Jun 2007 16:35:27 -0300 (ADT)
Received: from 227-54-222-209.mycybernet.net ([209.222.54.227]
	helo=phlogiston.dydns.org)
	by main2.mycybernet.net with esmtp (Exim 4.62)
	(envelope-from <ajs@phlogiston.dyndns.org>) id 1I2uLP-0006CH-2A
	for pgsql-sql@postgresql.org; Mon, 25 Jun 2007 15:35:27 -0400
Received: by phlogiston.dydns.org (Postfix, from userid 1000)
	id A14D9404E; Mon, 25 Jun 2007 15:35:21 -0400 (EDT)
Date: Mon, 25 Jun 2007 15:35:21 -0400
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Subject: Re: NO DATA FOUND Exception
Message-ID: <20070625193521.GI19717@phlogiston.dyndns.org>
References: <37E566AC-D304-4D52-920B-7FA61D7777FD@myemma.com>
	<04e701c7b75d$e9e5c6e0$8f01010a@iptel.com.ar>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <04e701c7b75d$e9e5c6e0$8f01010a@iptel.com.ar>
User-Agent: Mutt/1.5.9i
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200706/206
X-Sequence-Number: 28696

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.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
I remember when computers were frustrating because they *did* exactly what 
you told them to.  That actually seems sort of quaint now.
		--J.D. Baldwin