Received: from speedy.i-bucks.com ([216.2.101.40]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f25J09x22797 for ; Mon, 5 Mar 2001 14:00:09 -0500 (EST) (envelope-from jr@i-bucks.com) Received: from CBL-riehl (CBL-riehl.hs.earthlink.net [209.178.111.84]) by speedy.i-bucks.com (8.9.3/8.9.3) with SMTP id LAA05037 for ; Mon, 5 Mar 2001 11:00:13 -0800 Message-Id: <3.0.6.32.20010305110241.007f2e50@mail.i-bucks.com> X-Sender: jr@mail.i-bucks.com X-Mailer: QUALCOMM Windows Eudora Light Version 3.0.6 (32) Date: Mon, 05 Mar 2001 11:02:41 -0800 To: pgsql-interfaces@postgresql.org From: jr@i-bucks.com Subject: return codes Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Archive-Number: 200103/47 X-Sequence-Number: 1208 How does one check return codes with an embedded sql program? (I dont seem 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 examples of using postgres than the docs and Bruce's book. thanks, jr