Re: [PATCH] Add support for INSERT ... SET syntax

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PATCH] Add support for INSERT ... SET syntax
Дата
Msg-id 2009392.1774882572@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [PATCH] Add support for INSERT ... SET syntax  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-hackers
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Monday, March 30, 2026, Suraj Kharage <suraj.kharage@enterprisedb.com>
> wrote:
>> I would like to propose adding support for an alternative INSERT syntax
>> that uses named column assignments via a SET clause. This provides a more
>> convenient and readable way to write inserts, particularly when only
>> specific columns need values.

> -1 for inventing our own full variant of insert command syntax.

This has been discussed before, no?  I don't recall exactly why
we didn't adopt the earlier proposal(s), but some digging in the
mailing list archives should be fruitful.

            regards, tom lane



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