Re: So what's null then if it's not nothing?

From: Alfredo Novoa <alfredo_novoa_at_hotmail.com>
Date: 17 Nov 2005 02:59:07 -0800
Message-ID: <1132225147.734881.190190@f14g2000cwb.googlegroups.com>

michael_at_preece.net wrote:
> I've been accustomed to thinking of things either having a value or
> not. If something has no value then, to me, its value is null.

A clear contradiction! If something has no value then it has no value.

> Its
> value is an empty string (whatever "it" is).

An empty string is a string like any other.

>Does SQL's definition of null (unknown) include the null
> I'm familiar with (no value)? That doesn't make sense. If we know
> something has no value then its not an unknown value is it?

Indeed, SQL nulls don't make sense. Nulls are a big mistake.

Regards
Alfredo Received on Thu Nov 17 2005 - 04:59:07 CST