BogDan Vatra wrote: > The following bug has been logged online: > > Bug reference: 1921 > Logged by: BogDan Vatra > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0.3 > Operating system: win xp pro > Description: NULL<>NULL ?!?!?!?!?!?!? > Details: > > 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. Regards Gaetano Mendola ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
