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

From Bruce Stephens
Subject Re: [SQL] NULL
Date
Msg-id 87u2mnttmt.fsf@cenderis.demon.co.uk
Whole thread Raw
In response to NULL  (Goran Thyni <goran@kirra.net>)
List pgsql-sql
Goran Thyni <goran@kirra.net> writes:

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

No, it's not required.  This came up before with the examples from
"The Practical SQL Handbook".  It would be nice to allow it, but there
was some reason why to do so would be non-trivial, which I forget.
Anyway, it's not in SQL-92.


pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [SQL] NULL
Next
From: Howie
Date:
Subject: Re: [SQL] how can tell if a column is a primary key?