Re: [SQL] not null - trivial, unexpected behavior

2001-06-16 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > John Scott writes: >> but, as i understand the sql92 standard, both att = null and att != null >> are NOT sql92. > They are. We just don't implement att = null right because of reasons > that can be found in the archives. In a very narrow sense, th

Re: [SQL] not null - trivial, unexpected behavior

2001-06-16 Thread Tom Lane
John Scott <[EMAIL PROTECTED]> writes: > select count(*) from A where b = null; /* Returns 1, ok */ > select count(*) from A where b != null; /* Returns 0 ... not ok! */ Uh ... there have been several threads about this just in the past couple days. See for example http://www.ca.postgre