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

>    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.

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....

--
Colin Dick
On Call Internet Services
cdick@mail.ocis.net