Re: Speaking of New Features

If it was as chet suggested, then how could you do

insert into t (a,b) select x,y from r;

It would mean you would need to have two valid syntaxes for the INSERT.

1.) insert into t(a,b) values ('a','b');
2) insert into t (a => 'a', b=>'b');

both would need to be valid. Not that that is a terrible thing but if you
are going to have both 'named' and 'positional' for INSERT, then you would
probably want both forms available for UPDATE as well.

Other related posts: