Horton

Re: [SQL] NULL

Bruce Momjian <pgman@candle.pha.pa.us>

View thread View on postgr.es
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Goran Thyni <goran@kirra.net>
Cc: pgsql-sql@postgreSQL.org
Date: 1999-11-15T19:23:58Z
Lists: pgsql-sql 
[Charset iso-8859-1 unsupported, filtering to ASCII...]
> 
> How about this according to SQL standard:
> 
> CREATE TABLE x { y integer NULL };
> 
> It suppose to mean that NULLs are explicitly allowed in 
> this field.
> Is this required by SQL-92?

If I remember correctly, only NOT NULL is supported by SQL-92.  Thomas
talked about adding support for it in some limited cases for 7.0.  There
are shift/reduce cases if it were allowed everywhere.


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026