Re: 3 value logic. Why is SQL so special?

From: frosty <frostyj_at_bogus.tld>
Date: Fri, 8 Sep 2006 12:49:37 -0700
Message-ID: <19mdnYFfPLquVJzYnZ2dnUVZ_rGdnZ2d_at_adelphia.com>


You should read the thread with the subject: "So what's null then if it's not nothing?"

-- 
frosty

Karen Hill wrote:

> X-No-Archive:yes
>
> I know that visual basic, lisp, python, c , c++ , perl, all have 2
> value logic. What makes SQL so special that it needs 3vl when all
> these langauges make do with 2vl?
>
> I read a book on SQL which was authored by Date before I knew of the
> whole Date controversy and when I was learning SQL. I was thoroughly
> confused when he went on a spiel about nulls. I echoed this sentiment
> at work and was chastized and told that Date is a kook. Yet I have
> some time later accepted nulls and work with them just fine. In the
> back of my mind though, coming from a C++ background I still feel that
> if c++ can make it on 2vl why not SQL?
>
> Why do nulls make us feel so strange?
Received on Fri Sep 08 2006 - 21:49:37 CEST

Original text of this message