Re: GET DIAGNOSTICS (was Re: [HACKERS] Open 7.1 items)

[Tom Lane]

Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Bruce Momjian writes:
> I just committed changes that make it RESULT_OID, but if you like
> INSERTED_OID better, we could change it...
>> 
>> I think I like RESULT_OID because the standard uses RESULT.

> RESULT* is used for SELECT statements, but RESULT_OID is for INSERT
> commands.  It sounds a bit like that results get oids assigned.  Maybe.

I don't have a strong feeling either way, but it occurred to me that
RESULT_OID might be better since it could be used for more purposes,
eg, returning a last-affected-row OID for UPDATE or DELETE.  Not that
we do that now, but we wouldn't have to chew up additional keywords
if we wanted to start doing it.

                        regards, tom lane