'' != NULL in PostGres???
От | Neil Harkins |
---|---|
Тема | '' != NULL in PostGres??? |
Дата | |
Msg-id | Pine.GSO.3.96.980922180351.20111M-100000@well.com обсуждение исходный текст |
Ответы |
Re: [SQL] '' != NULL in PostGres???
|
Список | pgsql-sql |
Hello. I am experimenting with Postgresql-6.3.2 on a RedHat 5.1 DEC Alpha: nuacct=> create table users ( nuacct-> recno int, nuacct-> custid int unique, nuacct-> username char(14) not null, nuacct-> service int nuacct-> ); NOTICE: CREATE TABLE/UNIQUE will create implicit index users_custid_key for table users CREATE nuacct=> insert into users values nuacct-> ( 0, 0, '', 0 ); INSERT 18241 1 ??? Shouldn't that have failed, generating an error ??? nuacct=> select * from users where username is null; recno|custid|username|service -----+------+--------+------- (0 rows) nuacct=> select * from users where username = ''; recno|custid| username|service -----+------+--------------+------- 0| 0| | 0 (1 row) nuacct=> \d users Table = users +----------------------------------+------------------------------+------+ | Field | Type |Length| +----------------------------------+------------------------------+------+ | recno | int4 |4 | | custid | int4 |4 | | username | char() not null |14 | | service | int4 |4 | +----------------------------------+------------------------------+------+ ???
В списке pgsql-sql по дате отправления: