> Vince Vielhaber <vev@michvhf.com> writes:
> > Shouldn't this insert fail? This is 7.0.3.
>
> > template1=# create table foo(x int,y varchar(10),z datetime);
> > CREATE
> > template1=# insert into foo(x,y,z) values(1,'asdf');
> > INSERT 19222 1
>
> We've always allowed trailing columns to be omitted, whether a column
> name list is specified or not. This is not per spec --- SQL92 and SQL99
> both say that all the columns must be provided --- but I'm rather
> hesitant to enforce the spec's stricter rule at this point. Seems like
> it'd probably break some existing apps.
>
> A compromise position would be to allow dropping trailing columns only
> when the column name list is omitted.
Yikes, we allow the column to be missing even if they specify it in
INSERT. That seems very wrong.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026
