Request a Demo
Home   >   mailing lists

Re: [PATCH] Add support for INSERT ... SET syntax - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: [PATCH] Add support for INSERT ... SET syntax
Date
Msg-id 883c2802-dfc6-47d3-b24c-04f138c7f93c@dunslane.net
Whole thread Raw
In response to Re: [PATCH] Add support for INSERT ... SET syntax  (Álvaro Herrera <alvherre@kurilemu.de>)
List pgsql-hackers
Tree view 
On 2026-03-30 Mo 11:49 AM, Álvaro Herrera wrote:
> On 2026-Mar-30, Andrew Dunstan wrote:
>
>> 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.)
> Hmm, I don't see any WIP patch from you


No, I haven't submitted it, still working on it. Given Suraj's work, I 
will probably just submit a patch for INSERT BY NAME now.


cheers


andrew

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

pgsql-hackers by date:

Previous
From: Matthias van de Meent
Date:
Subject: Re: [BUG] Excessive memory usage with update on STORED generated columns.
Next
From: Alexander Lakhin
Date:
Subject: Re: Don't synchronously wait for already-in-progress IO in read stream