Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w7DlC-0055LS-1c for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Mar 2026 14:38:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w7DlB-003mIc-06 for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Mar 2026 14:38:33 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w7DlA-003mIR-2O for pgsql-hackers@lists.postgresql.org; Mon, 30 Mar 2026 14:38:33 +0000 Received: from mail-oo1-xc30.google.com ([2607:f8b0:4864:20::c30]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w7Dl8-000000020ZG-2QFo for pgsql-hackers@lists.postgresql.org; Mon, 30 Mar 2026 14:38:32 +0000 Received: by mail-oo1-xc30.google.com with SMTP id 006d021491bc7-67bbea1e090so2635521eaf.3 for ; Mon, 30 Mar 2026 07:38:30 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774881509; cv=none; d=google.com; s=arc-20240605; b=kc4T5tk7V9KRGF6vL8JdLC784dLpt0u5WstZlY/H6rH1DNLrWVqmFo0F6HC2hHls5Q v9qu3xhL5DJBNOx+0uIfbdArg0x+NRgtNczeAuRM812YiL3gWtetj/FGhj6pK8D7Dtk9 oTcoUQ3Q1xbMsea/kqFY15OE3WW4qek6YK5tSrAHARZwtY36Z7oxpKHwGEAdgJsw3w8j 0ChySbmnJPB4v95oKOmP/cYaNxOJv6aWXebq6BsqXnbpxXFxkHIgZwtX9el1su/SwnnC n6SXyB/TR7k0n/UioTjTOOtWFDLdkjOw++/rTvbTJ5uTQT+o7ef9z+29XxyzmnIKr8lR dkrQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:dkim-signature; bh=FMJ4vAbPsmgoPpUgdKMEqj5a3n8gTz+zcDpT4KmlSIM=; fh=Gj/QJzzyX2r+/J2ONn/3y6nSXJapWIzZA0UMNY8FC0s=; b=QumLppOOo3tLXoxtyFWsFHTfArJHG/A9BVWcmaY64Ezj3aPfOKWx368Lf5QwvUIK/4 mvafAjrRzhSyvYmj6yYVFKBUV68nwL+dix1R16GgX8sOHKm2UL7XX3nMGypkb1rDeKf5 2fxws/+3lGMQIW/cJb6Ky6HOscpCfbJ1uxQbtcadAexw59+g2q4f25Ls9dvfeRIQZ6eR YmZEajYKTnizSjZmREPdKpZP+/2QvBB5704DJAwr7B0OOlFY3XujFCoaGxcbGPR3eGNB lmJuU7eAcmqvvI1J4fJSJHkUQcV5C9gfWLa4gqzDYX2omyqn7rEbPBSMCr87JAd1Ps5v +nhw==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1774881509; x=1775486309; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=FMJ4vAbPsmgoPpUgdKMEqj5a3n8gTz+zcDpT4KmlSIM=; b=llwGGuslXNAe+tiolLAfOsEDnWP4D0m+qiOhTF6Z8ydi8DYdKMu/PtMgsDZcYM62oE 1v0uv5a8aESsHKWcRbr7wwj3A2UcXQeblclIyLLv9gKvshJulds+frDizJmTKGh3PPpS HDB7U5XGA7VQUi90PA/1qn+DHSU4r/24ZupFk76S1aWynrxOkM1zJklfkwTl5sAn+hdJ H//ZdCZlP3G2JvQNnd5lhDcR9tggm7OFYyW6FSh5akzez63nXQIZqJDMsjGJ5LRv5S14 MSwIJIRR6ti5N/XmEYcOafF6mFCT43+FkyIkCHWe4ayv56f6Lb1IcTuUlCpCkgzCMzjB dYSg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774881509; x=1775486309; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=FMJ4vAbPsmgoPpUgdKMEqj5a3n8gTz+zcDpT4KmlSIM=; b=ClNTWJtzLQ1f1t42SGNRyrNVKz2zkl+L8oRwRP6JgPwhY/TjETSjyqRmu9beY/nT/p Iq4daUUggD7jEuiEOU10zGxPqY1ns0kf4G7Y6uvz8cT2i5emp1w3FGMIwxcRIt235mXj ryxc87HDXEJli7nb8k9SuM6HY1CaOsDtnQpVZ9Jqg/tNd22sFqarj3p2JnD7HR5a7PlR yN05rn2sp993hthbayZlrBbaO5DHwL13I84g3djYeLujU0eqRpqmlZNKZ49xxY7wsBIj eGlZZuq+yaaF7zHDD6QBBaJy9u/5ux3OxoWHLqRkQrfiIumG4EqKbM6pdswLF8vPone7 CH7Q== X-Gm-Message-State: AOJu0YwHExGR7IbC5XkTXXwHcQwQfLsIzxM/8NgvmuqnedpJ0BhLe+5s 0I/GynCYP1zUi+rLEeW9SoqJyt2uM7DZDZOvivitjCM2e0tSYJYbnlhE52DfXX/pocKkmdB5wvM cPc7DbnNuLUhpuybojdFZ6w7TTeU2PqEVSgEI X-Gm-Gg: ATEYQzxaVquXb1GkNTxBpbOwXzDSEAZEmEd6BSgqdfgkljheg7r29jr2mPU6+T5hWNj ujOGPhcnujgm56vliMbAEsQm3KKGg1NzImMBl6Dt9BJoj2OUp448SSyw4cyWocJKJDFZlLfxN/L EUFpQD+98/qw9z8NImiFRVYlJDehp0AZjoByWmd/2nFAg2hjIGroWhAc0tsPDFmyzyggkqlvDCS Daz/ccZvDy6tbskc8mC0EB7p6A8tqwBZkD9GEHSHxpnpHzjL3uY837m81gIpF1c6n4IZ7+WQYKB SXlQbCATbaODeJMT7gtK7dDm510gZNn/7QFjWSkB X-Received: by 2002:a05:6820:16a2:b0:67c:2f81:d54a with SMTP id 006d021491bc7-67e1860f3e8mr6743944eaf.19.1774881508933; Mon, 30 Mar 2026 07:38:28 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a05:6802:3619:b0:625:d071:a21b with HTTP; Mon, 30 Mar 2026 07:38:27 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Mon, 30 Mar 2026 07:38:27 -0700 X-Gm-Features: AQROBzACfnjHsbkud45QxStEfmQEJzfXOI1lr9oPfiO8ZQOL1oMi8PFFb9CsCjE Message-ID: Subject: Re: [PATCH] Add support for INSERT ... SET syntax To: Suraj Kharage Cc: PostgreSQL Hackers Content-Type: multipart/alternative; boundary="000000000000dbc574064e3ecd82" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000dbc574064e3ecd82 Content-Type: text/plain; charset="UTF-8" On Monday, March 30, 2026, Suraj Kharage 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. --000000000000dbc574064e3ecd82 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Monday, March 30, 2026, Suraj Kharage <suraj.kharage@enterprisedb.com> wrote:
I would like to propose adding s= upport 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.
<= /blockquote>

-1 for inventing our own full variant of in= sert command syntax.

David J.

--000000000000dbc574064e3ecd82--