Re: Three valued logic (again)

Nils Myklebust wrote: > <snip> > > The above is the correct behaviour as far as I can see, and if your Yes, that was my view, too. The author of the statement concerned needed a little persuasion. The way 4 behaved made things too convenient for him so I think his judgement was based on "ease of use". My response would be that if I needed to write a statement which took the nulls into account I could do it in 7 by leaving out the WHERE clause with "IS NOT NULL" in it but I couldn't do it in 4. If I want to write a statement which ignores the nulls in the way 4 does I can still do it in 7 by including the WHERE clause. IMHO versatility wins over ease of use. > OnLine 4.11 behaves differently there is a defect in it. Although your > explanation of the difference seems plausible there *may* be other > explanations, and I would test it on a very simple select before I > declared it a defect. > As 4 is no longer a current product I don't suppose Informix would treat it as a defect to be remedied - but does anyone know which way 5 handles it? Ian