Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: c.d.theory glossary - NULL

Re: c.d.theory glossary - NULL

From: Leandro Guimar„es Faria Corsetti Dutra <leandro_at_dutra.fastmail.fm>
Date: Tue, 27 Apr 2004 10:50:16 -0300
Message-ID: <pan.2004.04.27.13.50.08.841038@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 - 08:50:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US