Re: NO DATA FOUND Exception

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: NO DATA FOUND Exception
Date: 2007-06-25 19:35:21
Message-ID: 20070625193521.GI19717@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice 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.

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrián Ribao Martínez 2007-06-25 19:45:44 Re: acampada
Previous Message Fernando Hevia 2007-06-25 19:20:37 NO DATA FOUND Exception

Browse pgsql-novice by date

  From Date Subject
Next Message Fernando Hevia 2007-06-25 19:55:58 Re: NO DATA FOUND Exception
Previous Message Fernando Hevia 2007-06-25 19:20:37 NO DATA FOUND Exception

Browse pgsql-sql by date

  From Date Subject
Next Message Fernando Hevia 2007-06-25 19:55:58 Re: NO DATA FOUND Exception
Previous Message Fernando Hevia 2007-06-25 19:20:37 NO DATA FOUND Exception