Received: from finch-post-10.mail.demon.net (finch-post-10.mail.demon.net [194.217.242.38]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA53381 for ; Mon, 15 Nov 1999 14:57:41 -0500 (EST) (envelope-from bruce@cenderis.demon.co.uk) Received: from cenderis.demon.co.uk ([193.237.0.193]) by finch-post-10.mail.demon.net with esmtp (Exim 2.12 #1) id 11nSFv-000BwR-0A for pgsql-sql@postgreSQL.org; Mon, 15 Nov 1999 19:57:40 +0000 Received: by cenderis.demon.co.uk (Postfix, from userid 1000) id 4A19C2A57D; Mon, 15 Nov 1999 19:57:52 +0000 (GMT) To: pgsql-sql@postgresql.org Subject: Re: [SQL] NULL References: <383059DA.9D2AF70D@kirra.net> From: Bruce Stephens Date: 15 Nov 1999 19:57:46 +0000 In-Reply-To: Goran Thyni's message of "Mon, 15 Nov 1999 20:07:06 +0100" Message-ID: <87u2mnttmt.fsf@cenderis.demon.co.uk> User-Agent: Gnus/5.070098 (Pterodactyl Gnus v0.98) XEmacs/21.2 (Yoko) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Lines: 14 Goran Thyni 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.