| Lists: | pgsql-interfaces |
|---|
| From: | jr(at)i-bucks(dot)com |
|---|---|
| To: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | return codes |
| Date: | 2001-03-05 19:02:41 |
| Message-ID: | 3.0.6.32.20010305110241.007f2e50@mail.i-bucks.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-interfaces |
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
| From: | Michael Meskes <meskes(at)postgresql(dot)org> |
|---|---|
| To: | jr(at)i-bucks(dot)com |
| Cc: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: return codes |
| Date: | 2001-03-06 08:40:28 |
| Message-ID: | 20010306094028.A24036@feivel.credativ.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-interfaces |
On Mon, Mar 05, 2001 at 11:02:41AM -0800, jr(at)i-bucks(dot)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(at)Fam-Meskes(dot)De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!