Re: [SQL] '' != NULL in PostGres??? - Mailing list pgsql-sql

From James Olin Oden
Subject Re: [SQL] '' != NULL in PostGres???
Date
Msg-id 81Sep22.163951edt.35713@gateway.lee.k12.nc.us
Whole thread Raw
In response to Re: [SQL] '' != NULL in PostGres???  (Colin Dick <cdick@mail.ocis.net>)
List pgsql-sql


> 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


pgsql-sql by date:

Previous
From: lynch@lscorp.com (Richard Lynch)
Date:
Subject: Re: [SQL] Cursors
Next
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] Re: [SQL] 2 questions.