Re: So what's null then if it's not nothing?
Date: Fri, 25 Nov 2005 16:10:41 +0100
In article <1132926804.625596.34020_at_g47g2000cwa.googlegroups.com>,
> michael_at_preece.net wrote:
> > Any two variables/"fields" (of any type) with "no value at all" are,
> > indeed, equal.
> > Mike.
> So, using your valuation for equality, would a query asking for a
> pairwise list of people living in the same country produce a correct
> result if some pairs that happen to have nulls for their countries ?
That, of course, depends on what you mean by a correct result, what it means that country is NULL, and how the query is formulated.
If we assume that it is not generally the case that two people with NULLs for their countries (speaking loosely here) live in the same country, the query would simply have to be written so as to disregard people with NULL country.
-- JonReceived on Fri Nov 25 2005 - 16:10:41 CET