From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Subject: Re: NO DATA FOUND Exception
Date: Mon, 25 Jun 2007 15:35:21 -0400
Message-ID: <20070625193521.GI19717@phlogiston.dyndns.org> (raw)
In-Reply-To: <04e701c7b75d$e9e5c6e0$8f01010a@iptel.com.ar>
References: <37E566AC-D304-4D52-920B-7FA61D7777FD@myemma.com>
<04e701c7b75d$e9e5c6e0$8f01010a@iptel.com.ar>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ajs@crankycanuck.ca
Subject: Re: NO DATA FOUND Exception
In-Reply-To: <20070625193521.GI19717@phlogiston.dyndns.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox