Re: MERGE ... RETURNING

Поиск
Список
Период
Сортировка
От Vik Fearing
Тема Re: MERGE ... RETURNING
Дата
Msg-id 71d8de80-91cb-aaf6-ee65-57ea8e3a1776@postgresfriends.org
обсуждение исходный текст
Ответ на Re: MERGE ... RETURNING  (Jeff Davis <pgsql@j-davis.com>)
Ответы Re: MERGE ... RETURNING  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-hackers
On 7/12/23 02:43, Jeff Davis wrote:
> On Sun, 2023-01-22 at 19:58 +0100, Alvaro Herrera wrote:
>>
>> (We do have to keep our fingers
>> crossed that they will decide to use the same RETURNING syntax as we
>> do
>> in this patch, of course.)
> 
> Do we have a reason to think that they will accept something similar?

We have reason to think that they won't care at all.

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.
-- 
Vik Fearing




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: [PoC] Federated Authn/z with OAUTHBEARER
Следующее
От: Andres Freund
Дата:
Сообщение: Re: DROP DATABASE is interruptible