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

Tom Lane wrote:
> Philip Warner <pjw(at)rhyme(dot)com(dot)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, ...;

I like this one - except for the OID which should IMHO read
INSERTED_OID.

> > 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 :-(

Actually it's more the "custody for my children" thing than
the movement itself. For the net-access: my mother's
appartment has a phone line, so I can use my 33K6 modem for
dialup - that's all.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com