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

From David G. Johnston
Subject Re: [PATCH] Add support for INSERT ... SET syntax
Date
Msg-id CAKFQuwbGSUXL5wfgPEnsGF3QTBHvOovNH9s1zUTUjv6Wocmk6w@mail.gmail.com
Whole thread
In response to [PATCH] Add support for INSERT ... SET syntax  (Suraj Kharage <suraj.kharage@enterprisedb.com>)
Responses Re: [PATCH] Add support for INSERT ... SET syntax
Re: [PATCH] Add support for INSERT ... SET syntax
List pgsql-hackers
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.

David J.

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Thread-safe getopt()
Next
From: Daniel Gustafsson
Date:
Subject: Re: Changing the state of data checksums in a running cluster