Received: from trillium.nmsu.edu (trillium.NMSU.Edu [128.123.5.15]) by hub.org (8.8.8/8.8.8) with ESMTP id OAA04909 for ; Wed, 23 Sep 1998 14:10:58 -0400 (EDT) (envelope-from brook@trillium.NMSU.Edu) Received: (from brook@localhost) by trillium.nmsu.edu (8.8.8/8.8.8) id MAA18985; Wed, 23 Sep 1998 12:10:47 -0600 (MDT) Date: Wed, 23 Sep 1998 12:10:47 -0600 (MDT) Message-Id: <199809231810.MAA18985@trillium.nmsu.edu> X-Authentication-Warning: trillium.nmsu.edu: brook set sender to brook@trillium.nmsu.edu using -f From: Brook Milligan To: nharkins@well.com CC: pgsql-sql@postgreSQL.org In-reply-to: (message from Neil Harkins on Wed, 23 Sep 1998 10:41:43 -0700 (PDT)) Subject: Re: [SQL] '' != NULL in PostGres??? References: nuacct=> create table users ( nuacct-> recno int, nuacct-> custid int unique, nuacct-> username char(14) not null, nuacct-> service int nuacct-> ); nuacct=> insert into users values nuacct-> ( 0, 0, '', 0 ); INSERT 18241 1 ??? Shouldn't that have failed, generating an error ??? No, but this will: nuacct=> insert into users values ( 0, 0, null, 0 ); '' is a zero length string not a null. Cheers, Brook