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.

Cheers,
Brook