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

On 2026-03-30 Mo 10:38 AM, David G. Johnston wrote:
> 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.


Well, Suraj has kinda beaten me to it, but he didn't invent this syntax. 
Oracle did 
<https://oracle-base.com/articles/23/non-positional-insert-into-set-and-insert-into-by-name-clauses-23> 
and I believe there is a proposal to add it to the standard. (Unlike 
Suraj's, my WIP patch also supports the INSERT BY NAME variant.)


cheers


andrew

--
Andrew Dunstan
EDB:https://www.enterprisedb.com