Message-ID: <c5090d60-09b3-4ca3-97cc-ddb99d87a301@proxel.se>
Date: Fri, 10 Jul 2026 10:52:36 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Proposal: INSERT ... BY NAME
From: Andreas Karlsson <andreas@proxel.se>
To: Jim Jones <jim.jones@uni-muenster.de>,
 Ayush Tiwari <ayushtiwari.slg01@gmail.com>,
 PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Cc: Peter Eisentraut <peter@eisentraut.org>
References: 
 <CAJTYsWVDs7vkEN-eD1NAnZ7XqcfpXu3tP1wMGzJQ12G6eo1oRw@mail.gmail.com>
 <e96b935f-0745-45da-9aa1-bed09d4be62d@uni-muenster.de>
 <52c9a352-0e4a-4eaa-a9e1-06fd33cf562f@proxel.se>
Content-Language: en-US
In-Reply-To: <52c9a352-0e4a-4eaa-a9e1-06fd33cf562f@proxel.se>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/c5090d60-09b3-4ca3-97cc-ddb99d87a301%40proxel.se>
Precedence: bulk

On 7/10/26 10:06, Andreas Karlsson wrote:
> According the accepted change proposal which was discussed when I was 
> there:
> 
> INSERT INTO t (a,b) BY NAME SELECT 37 AS b, 42 AS a;
> 
> is effectively the same thing as:
> 
> INSERT INTO t (a,b) BY NAME SELECT a, b FROM (SELECT 37 AS b, 42 AS a);

Sorry, saw a minor typo in my example, it should have been:

INSERT INTO t (a,b) BY NAME SELECT 37 AS b, 42 AS a;

is effectively the same thing as:

INSERT INTO t (a,b) SELECT a, b FROM (SELECT 37 AS b, 42 AS a);

-- 
Andreas Karlsson
Percona