Re: [SQL] Equivalent of Oracle SQL%NOTFOUND in plpgsql

2005-09-05 Thread Tom Lane
"Bath, David" <[EMAIL PROTECTED]> 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

[SQL] Equivalent of Oracle SQL%NOTFOUND in plpgsql

2005-09-05 Thread Bath, David
Folks, Background: I'm an old Oracle PL/SQL guy. In PL/SQL I can write some like the following: fetch cursorblah into blurble; if cursorname%NOTFOUND . or use the more general SQL%NOTFOUND symbol that is not specific to a cursor. There are similar "easy" variables t