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_at_b28g2000cwb.googlegroups.com>
X-No-Archive:yes
Date: 8 Sep 2006 12:05:15 -0700
Message-ID: <1157742315.903040.15430_at_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 - 21:05:15 CEST