Date: Tue, 6 Mar 2001 09:40:28 +0100
From: Michael Meskes <meskes@postgresql.org>
To: jr@i-bucks.com
Cc: pgsql-interfaces@postgresql.org
Subject: Re: return codes
Message-ID: <20010306094028.A24036@feivel.credativ.de>
Mail-Followup-To: jr@i-bucks.com, pgsql-interfaces@postgresql.org
References: <3.0.6.32.20010305110241.007f2e50@mail.i-bucks.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.3.15i
In-Reply-To: <3.0.6.32.20010305110241.007f2e50@mail.i-bucks.com>;
	from jr@i-bucks.com on Mon, Mar 05, 2001 at 11:02:41AM -0800

On Mon, Mar 05, 2001 at 11:02:41AM -0800, jr@i-bucks.com wrote:
> How does one check return codes with an embedded sql program?  (I dont seem

sqlca

> to find any info on this, in any of the documentation that I have seen).
> In other databases, I have checked the values of sqlca.sqlcode or similar
> fields.  While I see that this field exists, I dont know if postgres is
> similar in this request, and I dont know if there is a better source of

It is. There is also the exec sql whenever statement available.

> examples of using postgres than the docs and Bruce's book.

Unfortunately no.

Michael
-- 
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!