Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread 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

pgsql-hackers by date

Next:From: Vince VielhaberDate: 2001-12-27 23:17:29
Subject: Re: TODO question
Previous:From: Pavlo BaronDate: 2001-12-27 22:54:14
Subject: Re: TODO question

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group