Re: TODO question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Vince Vielhaber <vev(at)michvhf(dot)com>
Cc: Pavlo Baron <pb(at)pbit(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: TODO question
Date: 2001-12-27 23:07:07
Message-ID: 26942.1009494427@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Vince Vielhaber 2001-12-27 23:17:29 Re: TODO question
Previous Message Pavlo Baron 2001-12-27 22:54:14 Re: TODO question