BogDan Vatra wrote:
> The following bug has been logged online:
> Bug reference: 1921
> Logged by: BogDan Vatra
> Email address: bog_dan_ro(at)yahoo(dot)com
> PostgreSQL version: 8.0.3
> Operating system: win xp pro
> Description: NULL<>NULL ?!?!?!?!?!?!?
> Please execute this query:
> create table test (id serial, tt varchar(50));
> insert into test (tt) values(NULL);
> select tt from test where tt=NULL;
> This should return 1 row but ...
> An then try
> select tt from test where tt<>NULL;
> 0 row(s) !!!
This is not a bug. If you want find all values with that
field null you have to do:
select tt from test where tt is null;
And I can assure you this is what the standard say.
In response to
pgsql-bugs by date
|Next:||From: j6m||Date: 2005-09-29 15:02:39|
|Subject: Re: BUG #1921: NULL<>NULL ?!?!?!?!?!?!?|
|Previous:||From: Magnus Hagander||Date: 2005-09-29 13:25:33|
|Subject: Re: BUG #1920: Installer no WIN1252 & UTF8 selection|