Re: GET DIAGNOSTICS (was Re: Open 7.1 items)

> >> GET DIAGNOSTICS :c = OID;
> >
> >It looks to me like SQL99 allows
> >
> > GET DIAGNOSTICS :a = ROW_COUNT, :b = OID, ...;
>
> Yes, but condition information (eg. SPI RESULT or SQLCODE), needs a
> separate statement to row information (eg. ROW_COUNT). ie.
>
> GET DIAGNOSTICS :a = ROW_COUNT, :c = OID;
> GET DIAGNOSTICS EXCEPTION 1 :b = SQLCODE;
>
> but it's not much of a problem, really. And I agree the 'x = y' syntax is
> better.
>
> Unfortunately, I don't have an awful lot of free time at the moment, so I
> won't be able to look at this for at *least* as week.

Well, this clearly is a release-stopper because we don't want to release
a non-standard GET DIAGNOSTICS. It will be fixed before 7.1 final by
someone. I have added it to the open items list.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026