Received: from lee.k12.nc.us (mail.lee.k12.nc.us [207.4.71.118]) by hub.org (8.8.8/8.8.8) with ESMTP id RAA24878 for ; Wed, 23 Sep 1998 17:47:27 -0400 (EDT) (envelope-from joden@lee.k12.nc.us) Received: by gateway.lee.k12.nc.us id <35713>; Tue, 22 Sep 1981 16:39:51 -0400 Date: Wed, 23 Sep 1998 17:49:47 -0400 From: James Olin Oden X-Mailer: Mozilla 4.04 [en] (Win95; I) MIME-Version: 1.0 To: Colin Dick , "pgsql-sql@postgreSQL.org" Subject: Re: [SQL] '' != NULL in PostGres??? References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-Id: <81Sep22.163951edt.35713@gateway.lee.k12.nc.us> > I wonder, > Would > > insert into users (recno, custid, service) values (0, 0, 0); > > also fail? As far as I can tell, if you don't expressly populate the > field, it will remain as a null.... I believe that would should fail unless he has set some sort of default value for the field...james