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