Postgres Pro
Downloads
Home   >   mailing lists

Re: Equivalent of Oracle SQL%NOTFOUND in plpgsql - Mailing list pgsql-sql

From Tom Lane
Subject Re: Equivalent of Oracle SQL%NOTFOUND in plpgsql
Date
Msg-id 13560.1125973263@sss.pgh.pa.us
Whole thread Raw
In response to Equivalent of Oracle SQL%NOTFOUND in plpgsql  ("Bath, David" <dave.bath@unix.net>)
List pgsql-sql
Tree view 
"Bath, David" <dave.bath@unix.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

pgsql-sql by date:

Previous
From: "Bath, David"
Date:
Subject: Equivalent of Oracle SQL%NOTFOUND in plpgsql
Next
From: "Antony Sohal"
Date:
Subject: Weird Trigger Behaviour using IF ... THEN ... ESLEIF... THEN... ELSEIF... THEN ... ELSE ... END IF;