Philip Warner <pjw@rhyme.com.au> writes:
>> Hmm, that's definitely what SQL99 uses for the syntax. I wonder where
>> Jan got the SELECT INTO syntax --- did he borrow it from Oracle?
> Sadly, we made it up.
Ah so. Well, friendliness aside, I'd go with the spec's syntax.
> 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;
It looks to me like SQL99 allows
GET DIAGNOSTICS :a = ROW_COUNT, :b = OID, ...;
which is at least as good as the SELECT syntax, if not better since each
target variable and info spec are kept together.
> P.S. Is Jan around? He's been very quiet recently...
He's still engaged in moving from Germany to Norfolk, VA. I think his
net-access is somewhat erratic :-(
regards, tom lane