3 value logic. Why is SQL so special?

From: Karen Hill <karen_hill22_at_yahoo.com>
Date: 8 Sep 2006 12:05:15 -0700
Message-ID: <1157742315.903040.15430@b28g2000cwb.googlegroups.com>

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 - 14:05:15 CDT