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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Suraj Kharage <suraj(dot)kharage(at)enterprisedb(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: [PATCH] Add support for INSERT ... SET syntax
Date: 2026-03-30 14:38:27
Message-ID: CAKFQuwbGSUXL5wfgPEnsGF3QTBHvOovNH9s1zUTUjv6Wocmk6w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Monday, March 30, 2026, Suraj Kharage <suraj(dot)kharage(at)enterprisedb(dot)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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Gustafsson 2026-03-30 14:43:15 Re: Changing the state of data checksums in a running cluster
Previous Message Tom Lane 2026-03-30 14:34:40 Re: Thread-safe getopt()