Subject: Re: Proposal: INSERT ... BY NAME

From: Marcos Pegoraro <[email-masked]>
Date: Fri, 10 Jul 2026 11:44:55 -0300

Em sex., 3 de jul. de 2026 às 08:08, Ayush Tiwari <
[email-masked]> escreveu:

>   - BY NAME requires a query source and is rejected for VALUES and DEFAULT
>     VALUES.  BY POSITION is accepted with DEFAULT VALUES as a no-op.
>
Is it rejected for VALUES, even if those VALUES are named ?
This one should work, doesn't it ?
insert into t1 (c1, c2) by name select * from (Values (1,2)) x(c2, c1)

And is missing a test for select *, right ?
create table a(a int, b int, c int);
create table b(b int, c int, a int);
insert into a by name select * from b;

regards
Marcos