Re: c.d.theory glossary - NULL
Date: Tue, 27 Apr 2004 10:50:16 -0300
Message-ID: <pan.2004.04.27.13.50.08.841038_at_dutra.fastmail.fm>
Em Mon, 26 Apr 2004 07:55:50 -0400, Laconic2 escreveu:
> Special Values like "Not Available" or "Inapplicable" are really not
> values, if you think about them.
Why not?
Granted, inapplicable indicates a failure in modelling, specifically in normalisation.
> Adding them to the domain is just a perverse use of the domain. It's a
> kludge.
No, a domain is a set. There is no restriction to what you put there, you just have to take care to provide the operators and not complicate things unnecessarily...
> If there is a NULL bit for every cell, as there should be in a good
> RDBMS, it should be set to NULL in the cases listed above.
You unfortunately don't seem to have understood what is a NULL and what is the relational model. You seem to think SQL is relational. I fear that means you either can't or -- more probably -- don't want to learn otherwise, and thus your continued posting of such confused opinions make you a troll, if not a violent, man-eating, rock-fleshed one.
-- Leandro Guimarães Faria Corsetti Dutra +55 (11) 5685 2219 Av Sgto Geraldo Santana, 1100 6/71 +55 (11) 5686 9607 04.674-000 São Paulo, SP BRASIL http://br.geocities.com./lgcdutra/Received on Tue Apr 27 2004 - 15:50:16 CEST