Re: Proposal: INSERT ... BY NAME

Em sex., 3 de jul. de 2026 às 08:08, Ayush Tiwari <
ayushtiwari(dot)slg01(at)gmail(dot)com> 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