Received: from Radha.DoCS.UU.SE (root@Radha.DoCS.UU.SE [130.238.9.99]) by hub.org (8.9.3/8.9.3) with SMTP id LAA95726 for ; Tue, 30 Nov 1999 11:27:38 -0500 (EST) (envelope-from e99re41@DoCS.UU.SE) Received: from Vessla.DoCS.UU.SE (e99re41@Vessla.DoCS.UU.SE [130.238.9.188]) by Radha.DoCS.UU.SE (8.6.12/8.6.12) with ESMTP id RAA02685; Tue, 30 Nov 1999 17:27:35 +0100 Received: from localhost (e99re41@localhost) by Vessla.DoCS.UU.SE (8.6.12/8.6.12) with SMTP id RAA13411; Tue, 30 Nov 1999 17:27:34 +0100 X-Authentication-Warning: Vessla.DoCS.UU.SE: e99re41 owned process doing -bs Date: Tue, 30 Nov 1999 17:27:33 +0100 (MET) From: Peter Eisentraut Reply-To: Peter Eisentraut To: "Ross J. Reedstrom" cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] NULL In-Reply-To: <19991130101246.B6156@wallace.ece.rice.edu> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Tue, 30 Nov 1999, Ross J. Reedstrom wrote: > My recollection of this thread was that no one found any reason to > dis-allow NULL as a column (pseudo)constraint, other than it not being > in the SQL92 standard. In particular, I understood Jan to say that he That's a pretty strong reason, in absence of any other good ones. The product is called PostgreSQL and not PostgreSybase or whatever. We shouldn't have to follow other vendors' questionable decisions. It's not really that hard to prepare any incompatible dumps you might have. > tried it, and received no shift/reduce conflicts from flex. I think we > all agree with Tom that there's no need for it, so we shouldn't give up > anything else to get it, but several people mentioned having it easied > porting from Sybase, or some other commercial db, where the machine > generated DDL dumps include the NULL constraints. So, class it with the > other compatability hacks, and include it, perhaps? > > Ross > -- Peter Eisentraut Sernanders vaeg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden