Re: [SQL] '' != NULL in PostGres???

From: James Olin Oden <joden(at)lee(dot)k12(dot)nc(dot)us>
To: Colin Dick <cdick(at)mail(dot)ocis(dot)net>, "pgsql-sql(at)postgreSQL(dot)org" <pgsql-sql(at)postgreSQL(dot)org>
Subject: Re: [SQL] '' != NULL in PostGres???
Date: 1998-09-23 21:49:47
Message-ID: 81Sep22.163951edt.35713@gateway.lee.k12.nc.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas G. Lockhart 1998-09-24 02:34:24 Re: [HACKERS] Re: [SQL] 2 questions.
Previous Message Richard Lynch 1998-09-23 20:09:15 Re: [SQL] Cursors