Tom Lane wrote:
> 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, ...;
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@Yahoo.com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
