Re: SET NULL / SET NOT NULL - Mailing list pgsql-hackers

Thomas Lockhart wrote:
> ...
> > "CREATE TABLE test (x int NULL)" doesn't look great either.  :-)  What
> > is that NULL doing there?
> 
> Well, because NOT NULL *was* in the standard, and because one should be
> able to explicitly negate *that*. The alternative was
> 
>   CREATE TABLE test (x int NOT NOT NULL)
> 
> :O

Yea, what I meant is that NULL doesn't look too clear in CREATE TABLE
either.

--  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