Re: [SQL] NULL

From: Bruce Stephens <bruce(at)cenderis(dot)demon(dot)co(dot)uk>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] NULL
Date: 1999-11-15 19:57:46
Message-ID: 87u2mnttmt.fsf@cenderis.demon.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Goran Thyni <goran(at)kirra(dot)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.

In response to

  • NULL at 1999-11-15 19:07:06 from Goran Thyni

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Howie 1999-11-15 22:37:11 Re: [SQL] how can tell if a column is a primary key?
Previous Message Bruce Momjian 1999-11-15 19:23:58 Re: [SQL] NULL