From: "Bath, David" <dave.bath@unix.net>
Reply-To: dave.bath@unix.net
To: pgsql-sql@postgresql.org
Subject: Equivalent of Oracle SQL%NOTFOUND in plpgsql
Date: Tue, 6 Sep 2005 12:14:06 +1000
User-Agent: KMail/1.8
MIME-Version: 1.0
Content-Type: text/plain;
  charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200509061214.06644.dave.bath@unix.net>

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 to get at the SQLSTATE code
   and associated error message.

Question:
   How do I read the sqlstate for either/or the
   most recent SQL command or a nominated cursor
   from within plpgsql?  I can find relevant info
   for C/spi stuff, but can't see it for plpgsql.
   Am I blind, not looking in the right spot,
   is it undocumented, or unimplemented?

Thanks in advance
-- 
David T. Bath
dave.bath@unix.net