Re: The BOOLEAN data type

From: --CELKO-- <71062.1056_at_compuserve.com>
Date: 12 Apr 2003 16:40:48 -0700
Message-ID: <c0d87ec0.0304121540.648a04d8_at_posting.google.com>


>> Let there be a a panel of judges who will "judge" if Joe Celko's
contributions to the above threads are "good" as opposed to "bad" (unreasonable, misleading, containing bad advice) ... If I want to say that your contribution is good I'd put a "true". If I am in doubts or have mixed feelings, I don't want to pronounce, I won't insert anything. ... Voila: a natural usage of boolean datatype, *and* there are no NULLs in the table, and no NULLs are ever needed in this case ... <<

You never worked as a statistician! You need a subjective preference scale that has either 5 or 7 steps ("walks on water" to "sucks rocks") in the scale for this kind of task. More values in the scale and the results are not reproducible; fewer values and the test instrument is not usable :) Received on Sun Apr 13 2003 - 01:40:48 CEST

Original text of this message