Re: MERGE ... RETURNING
| От | Jeff Davis |
|---|---|
| Тема | Re: MERGE ... RETURNING |
| Дата | |
| Msg-id | 425bd4540c7bf6f35bf3afbef012fbf360d13764.camel@j-davis.com обсуждение исходный текст |
| Ответ на | Re: MERGE ... RETURNING (Vik Fearing <vik@postgresfriends.org>) |
| Ответы |
Re: MERGE ... RETURNING
|
| Список | pgsql-hackers |
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?
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.
Regards,
Jeff Davis
В списке pgsql-hackers по дате отправления: