> >> 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@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026