Re: TODO question

Vince Vielhaber <vev(at)michvhf(dot)com> writes:
> On Thu, 27 Dec 2001, Pavlo Baron wrote:
>> what is meant by the TODO-item "Disallow missing columns in INSERT ...
>> VALUES, per ANSI" ?

> INSERT INTO foo(a,b) values(1,2,3);

I think you mean

regression=# INSERT INTO foo(a,b,c) values(1,2);
INSERT 172219 1

as the other behaves as expected:

regression=# INSERT INTO foo(a,b) values(1,2,3);
ERROR: INSERT has more expressions than target columns

I am not sure why this is on the TODO list, as opposed to having been
fixed out-of-hand; it sure doesn't look complex to the naked eye.
Perhaps there were some compatibility concerns, or some other issue.
Pavlo would be well advised to go search the archives for awhile to
understand the background of the TODO item.

regards, tom lane