Re: [SQL] NULL - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] NULL
Date
Msg-id 19817.942713416@sss.pgh.pa.us
Whole thread Raw
In response to Re: [SQL] NULL  (wieck@debis.com (Jan Wieck))
Responses Re: [SQL] NULL  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-sql
wieck@debis.com (Jan Wieck) writes:
>     I can't see any shift/reduce conflicts if I place a
>         | NULL_P
>     case into the ColConstraintElem: definition right between the
>         | DEFAULT b_expr
>     and
>         | NOT NULL_P
>     cases. Could it be that this reason is out of date?

Could be.  I remember tweaking the ColConstraint grammar to avoid
shift-reduce conflicts with NOT NULL, and it might be that that got
rid of the problem with NULL as well.

It's still not legal under the SQL92 spec, though, and I'd hate to see
us give up anything else in order to allow a content-free NULL spec to
be added...
        regards, tom lane


pgsql-sql by date:

Previous
From: wieck@debis.com (Jan Wieck)
Date:
Subject: Re: [SQL] NULL
Next
From: "D'Arcy" "J.M." Cain
Date:
Subject: Re: [SQL] how can tell if a column is a primary key?