| From: | Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at> |
|---|---|
| To: | "'Philip Warner'" <pjw(at)rhyme(dot)com(dot)au>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | AW: GET DIAGNOSTICS (was Re: Open 7.1 items) |
| Date: | 2001-02-19 10:23:57 |
| Message-ID: | 11C1E6749A55D411A9670001FA687963368201@sdexcsrv1.f000.d0188.sd.spardat.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> We *do* need to support ROW_COUNT, but allowing
>
> GET DIAGNOSTICS Select ROW_COUNT, SQLCODE, OID Into :a,:b:,:c;
>
> is a lot friendlier than the standard:
>
> GET DIAGNOSTICS :a = ROW_COUNT;
> GET DIAGNOSTICS EXCEPTION 1 :b = SQLCODE;
> GET DIAGNOSTICS :c = OID;
>
> (not that we even support SQLCODE at this stage).
Informix does:
GET DIAGNOSTICS :a = ROW_COUNT, EXCEPTION 1 :b = SQLCODE;
separated with comma, don't know if that is standard, but it sure looks more
like the standard.
Andreas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sezai YILMAZ | 2001-02-19 11:50:05 | Turkish locale bug |
| Previous Message | Sascha Schumann | 2001-02-19 10:13:20 | Re: PHP 4.0.4pl1 / Beta 5 |