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