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 1w7HjT-0059As-3D for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Mar 2026 18:53:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w7HjR-005gh3-0r for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Mar 2026 18:53:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w7HjP-005ggp-2y for pgsql-hackers@lists.postgresql.org; Mon, 30 Mar 2026 18:53:01 +0000 Received: from mail-qt1-x843.google.com ([2607:f8b0:4864:20::843]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w7HjN-00000001qok-2ZMv for pgsql-hackers@lists.postgresql.org; Mon, 30 Mar 2026 18:52:59 +0000 Received: by mail-qt1-x843.google.com with SMTP id d75a77b69052e-50b35f3e489so57044691cf.0 for ; Mon, 30 Mar 2026 11:52:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dunslane-net.20230601.gappssmtp.com; s=20230601; t=1774896776; x=1775501576; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:autocrypt:content-language :from:references:cc:to:subject:user-agent:mime-version:date :message-id:from:to:cc:subject:date:message-id:reply-to; bh=4L0LVHsfjoXCok2HrGycx6Me5dliH85G+55DKMIW/dk=; b=hMoJrIlr6BEjaJKw3EFAhKfjDk/gXTmb1/KmkVczXW6cshkONVYk4Jk7IT4Or3SNEJ CL6lKA3tv0VtYGcidH/sSPVEiMiN8SBH90OB2Jj8EM4JK4NWEPajWIk9tuSIhYU3xnkV lIPDVS2AIwbNuj2t4xPrKL/xmNJE7LIe62sEhe9Rw9FRyPnyENa4Yakjg5eJi0iwxCET nJ8CGj8e50rfJPk8wMGza4ZtN8oiqUiT4kVioqV0Mvt6nq6QJdtYu+U6s3tqQDumB8WF BWdmvM1ZRI7F+Q0Vp11Jtb3qP6lHSNUTYhIZX5ZSAHvRKfoLRARoG1z7Ef9gLdnX9hdK U5WQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774896776; x=1775501576; h=content-transfer-encoding:in-reply-to:autocrypt:content-language :from:references:cc:to:subject:user-agent:mime-version:date :message-id:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=4L0LVHsfjoXCok2HrGycx6Me5dliH85G+55DKMIW/dk=; b=HdefofyyFbtFeZjo47TY8OB4K+elrHVhHYybDRIDSLPEscyKPXxqRTZf4xYMUILoav NVB05zivIvWnSJne9oiooSKwKYeML+OxBTbexqtBumTE4rDkXxSSx+iHUWHWprKW1c3j W5tWrZW2gtvONGttYgP+8TZpxiC4v/d6dMYtPiCOS7ywRrMEjTjPBo/PMycg4zUwEUhP oWg0Juh77yMQ9ZJydFox8s3YhJyOdBrPSrIiQeKxO/XdYef29hDaAom5XFhx1lqC0b+/ quwARj93sP91/a/jctmyHB5DfpIGgejWanN6YtOt7On49IdGQEA70Cyoj5k9Mg5fChpa Embw== X-Forwarded-Encrypted: i=1; AJvYcCXxSXnRaDJP4g4PiETAxolaYaEI4L4PI/BtNNqtxviTJFMBPVqzCO0/C6uMdz4XInqTa32OIUVPE2h4CUVz@lists.postgresql.org X-Gm-Message-State: AOJu0YwNiGjEtEOcyB1OmjIbEy0wkLLzBvmJS1Izyvw9IpwWExb9lMG/ yP/JfiV5x1dooH9N+OmqFMjYa6JZAw4qHZGI5qENqsieRZKLYcoKmfIgCgW7alCZtJs= X-Gm-Gg: ATEYQzyzYXdEnbejxzOY4yQ+N6rmNOViGuvXTj515xQRDz5KZLCKrOr4uwrZDZOo7sa jMFYBlJGA7P3xVY6lr+b7ZUqlE6FrEV4PqcO4bGB5DdIA262siIEkVr9Ax1sLzQGLVpnSABwXca Ud9z6mc3gZ8n6P0r6CkrxPp2n8dGV4oooyBYgtQrhkaqBsSCrXKvRtSh8/ACuv5e39StDmkA4SY f2goHQLg3FBOkQ96+5/X+0f6NWg+jHnnAENwcxkLCjoG9Uhfr7QGf/UHKYNjjhslDFvHI9NcPEG YG2SDdma04U46icuWRtCvHaZ9YeuMUv5MIa7IvsDy3s/LFgey09nFMdauA66KfIY6CVo7qV8GF7 b0zrsW66G0Yb2wDVsaJ92UiXFHC6F/MbReuapwv8Z9Xxz7w6YoPnFugxCBJOpViBE0b6n9QEGxB yMismNtYuIlDvPSYiWiZabCFMNUqZ70Q== X-Received: by 2002:ac8:58d5:0:b0:4f7:a06d:c4df with SMTP id d75a77b69052e-50d2c92fa59mr9728171cf.33.1774896775715; Mon, 30 Mar 2026 11:52:55 -0700 (PDT) Received: from ?IPV6:2605:a601:a6b0:500::1cb? ([2605:a601:a6b0:500::1cb]) by smtp.googlemail.com with ESMTPSA id d75a77b69052e-50bb2c67beasm71433751cf.5.2026.03.30.11.52.55 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 30 Mar 2026 11:52:55 -0700 (PDT) Message-ID: <883c2802-dfc6-47d3-b24c-04f138c7f93c@dunslane.net> Date: Mon, 30 Mar 2026 14:52:54 -0400 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: [PATCH] Add support for INSERT ... SET syntax To: =?UTF-8?Q?=C3=81lvaro_Herrera?= Cc: "David G. Johnston" , Suraj Kharage , PostgreSQL Hackers References: <202603301544.utwvuj534m36@alvherre.pgsql> From: Andrew Dunstan Content-Language: en-US Autocrypt: addr=andrew@dunslane.net; keydata= xsBNBE7KWFkBCAClridxur2AIc7eW2AR7izbfp3EnNefie2HbLF0izW5Ik5UjX2HBXBx4syI gY6b0ugohXrr274+baoAlvSbq6cAoQuEVrk5IZFzt20b1Xkx65FwGSEj526yiKLocqkJceSq Xr9xcA5SGY+FZv441chh5SU92v4q6z+6LPpoHOh97ptAVXZYNTtU0LevyvD5lja0TzbvJm6C eFXitJfnm1pLEr0DGJCR/iUOl/N62Kh4855zZC7NHIjQHPOvV5Stz/l5ilDhvGVk+xkXFPys SjZoUr1rXhYLpiyi5sR0X9FHXT0KnGuz1F5ERO7ZTLSSQ6fJwPj6gOk9K+vvoKvoeql5ABEB AAHNJEFuZHJldyBEdW5zdGFuIDxhbmRyZXdAZHVuc2xhbmUubmV0PsLAlwQTAQgAQQIbAwIX gAIZAQULCQgHAwUVCgkICwUWAgMBAAIeBRYhBOQ+WEYd/Hy/RGkVpZn6f8tZ/DuBBQJoGNGd BQkdEO8nAAoJEJn6f8tZ/DuBq74H/jkTR4Zi3stbw+xC7v2u3QozssK7MYPL2AsVfh7OealS h182fiWXpfvmmAB7WUHbhk9GC2RAOnHI/2d2jgKaMLAHsGYOT0YopTVIwRY43fCw/mK67yxc wmDcX+zyKfLaivNbf5A7QPLNwda98bEAMSJ8Sn652Uc6cA8t3uKGsVzbRBQOoYzjgvBCfSrE 9ql3PDNg0l4BfAqabd2f70ZUm9VAMEPrgv/v2xI7M2XiL4g5BVmqLCOwxLM8RMCotCuoweUr VO43DeBCIDwLxotMJKvGWDjBzQYlU1NPUAtNcz/gN9ITUe1VUGjyvGj4u1lxBOcQQUw7l1+T 5moZ4iZxXzvOwE0ETspYWQEIANGc4zQULOxhbqO2dyD51YhqCNRmm9oKWaqf+wmW4tpDe/VV cxAnNizd4LWCHfzpb5cHAtGkOPePMfzWVf6nvdF7d3eglbtf59+zG7O7llV0xSSoFiieQBsr GvqDInXYX/4mRRXMtyhM353/tixC9RWLs1oofyYmCPPXXY7h9R7en3B8BoVrRFcdzlIY/NFN hFGW/9dkEiGjgna2Rk6e15kln4ZvFBWUg23p93w/pqXcxY6+k/8TEk+C4R+M6w7o2PLGOjdZ +kPiUcw5H85zf/yZJwQXzisXaNduwWB6Vads9YC9dj6kPR1c4VGRqAaYL++LAEOqrlvm2Tvq QqZRtnEAEQEAAcLAfAQYAQgAJgIbDBYhBOQ+WEYd/Hy/RGkVpZn6f8tZ/DuBBQJoGNI2BQkd EODdAAoJEJn6f8tZ/DuBfw0IAKTsfD40teP/pp+bsLLMSxPXUYrrprTj7WFB5v61p6dkpSr/ qXmMlyahdxQFaPmfVgVirB1Vk/kHiWNnnGjfUV9nB2Zg9LI0Xb9/ts3LsUiRWXzG3tkMY6XL vsVOxW4XFRND9l2q+WW93aZ1DZl+fqWfYgMvsusFRhmGFOKTRfKPta2Pkv+AhA24N4+PrR5p bU4k2MO8PAGiK8eaYKGFG1bHKuAvoDoF7WXJ3FHxuWqLnKEt4dfOLm5pAe3zq1Lt6q8azT9i QWGpSAK5vQUWQHBHpiDjdPeqKZ6HiAXIIKfSmb+jrvXBqoP+D6/K7rUjG2aXiRtTIAXms9sm VRu7cmw= In-Reply-To: <202603301544.utwvuj534m36@alvherre.pgsql> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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 >> 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