Re: [PATCHES] ANSI Compliant Inserts - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [PATCHES] ANSI Compliant Inserts
Date
Msg-id Pine.LNX.4.30.0204150023520.717-100000@peter.localdomain
Whole thread Raw
In response to Re: [PATCHES] ANSI Compliant Inserts  ("Rod Taylor" <rbt@zort.ca>)
List pgsql-hackers
Rod Taylor writes:

> I submitted a patch which would make Postgresql ANSI compliant in
> regards to INSERT with a provided column list.  As Tom states below,
> this is not full compliance.
>
> CREATE TABLE tab(col1 text, col2 text);
>
> INSERT INTO tab (col1, col2) VALUES ('val1'); -- bad by spec (enforced
> by patch)
> INSERT INTO tab (col1, col2) VALUES ('val1', 'val2'); -- good
>
> INSERT INTO tab VALUES ('val1'); -- bad by spec (not enforced)
> INSERT INTO tab VALUES ('val1', 'val2'); -- good

I recall that this was the behavior we agreed we wanted.  IMHO, it would
be conditional on the INSERT ... VALUES (DEFAULT) capability being
provided.  I'm not sure if that is there yet.

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: "Rod Taylor"
Date:
Subject: Re: [PATCHES] ANSI Compliant Inserts
Next
From: Curt Sampson
Date:
Subject: Re: 7.3 schedule