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

From Tom Lane
Subject Re: [PATCH] Add support for INSERT ... SET syntax
Date
Msg-id 2009392.1774882572@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCH] Add support for INSERT ... SET syntax  ("David G. Johnston" <david.g.johnston@gmail.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Thread-safe getopt()
Next
From: Ants Aasma
Date:
Subject: Re: Proposal for enabling auto-vectorization for checksum calculations