Re: MERGE ... RETURNING

On 7/13/23 01:48, Jeff Davis wrote:
> On Wed, 2023-07-12 at 03:47 +0200, Vik Fearing wrote:
> 
>> There is no RETURNING clause in Standard SQL, and the way they would
>> do
>> this is:
>>
>>       SELECT ...
>>       FROM OLD TABLE (
>>           MERGE ...
>>       ) AS m
>>
>> The rules for that for MERGE are well defined.
> 
> I only see OLD TABLE referenced as part of a trigger definition. Where
> is it defined for MERGE?

Look up <data change delta table> for that syntax.  For how MERGE 
generates those, see 9075-2:2023 Section 14.12 <merge statement> General 
Rules 6.b and 6.c.

> In any case, as long as the SQL standard doesn't conflict, then we're
> fine. And it looks unlikely to cause a conflict right now that wouldn't
> also be a conflict with our existing RETURNING clause elsewhere, so I'm
> not seeing a problem here.

I do not see a problem either, which was what I was trying to express 
(perhaps poorly).  At least not with the syntax.  I have not yet tested 
that the returned rows match the standard.
-- 
Vik Fearing