Re: Equivalent of Oracle SQL%NOTFOUND in plpgsql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: dave(dot)bath(at)unix(dot)net
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Equivalent of Oracle SQL%NOTFOUND in plpgsql
Date: 2005-09-06 02:21:03
Message-ID: 13560.1125973263@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Bath, David" <dave(dot)bath(at)unix(dot)net> writes:
> In PL/SQL I can write some like the following:
> fetch cursorblah into blurble;
> if cursorname%NOTFOUND .....

See the FOUND variable:
http://www.postgresql.org/docs/8.0/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Dinesh Pandey 2005-09-06 04:18:14 Re: Table Constraint CHECK(SELECT()) alternative?
Previous Message Bath, David 2005-09-06 02:14:06 Equivalent of Oracle SQL%NOTFOUND in plpgsql