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');
and
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.
Mike

Other related posts: