List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:March 14 2009 12:36pm
Subject:Re: avoiding use of Nulls (was: The <=> operator)
View as plain text  
Hi everybody I want to join as well.

>
> But hypothetically speaking, what value would you use if you didn't have a
> "I don't what this is" value  like null?


>
> I ask this because I started programming when NULL was really zero, and
> part of the ASCII collating sequence.

NULL was zero

>
>
>  I'd use -99999.9999, I'd never allow a "i don't know what it is" value
> like Null in my database.
>

NULL is NO INFORMATION ON THIS VALUE, and having no information happens in
real life.
The message I do not have information on this value it is an important
information itself.

The question is: "Will I allow a record to contain a 'non-informative' field
?"

[a] Ok, go ahead.
[b] No, set the field as NOT NULL

If you choose [b] please assume your responsibilities.
Everytime you insert a record, either you have all the information at once
or use your fake,
fantasy value {0,-99999.9999,-1,PIPPO}.
If I read your record about the weather in Amsterdam and I read a
temperature of -99999.9999
I will definitely think your database is unreliable.

Cheers

Claudio

Thread
The <=> operatorMorten13 Mar
  • Re: The <=> operatorMichael13 Mar
    • avoiding use of Nulls (was: The <=> operator)Ray13 Mar
      • Re: avoiding use of Nulls (was: The <=> operator)michael13 Mar
        • Re: avoiding use of Nulls (was: The <=> operator)Thomas Spahni13 Mar
          • Re: avoiding use of Nulls (was: The <=> operator)michael13 Mar
            • Re: avoiding use of NullsAndy Wallace13 Mar
              • Re: avoiding use of NullsArthur Fuller14 Mar
            • Re: avoiding use of NullsPJ13 Mar
            • Re: avoiding use of Nulls (was: The <=> operator)Claudio Nanni14 Mar
              • Re: avoiding use of Nulls (was: The <=> operator)Morten14 Mar
              • Re: avoiding use of Nulls (was: The <=> operator)michael14 Mar
                • Re: avoiding use of Nulls (was: The <=> operator)Mattia Merzi15 Mar
                • Re: avoiding use of Nulls (was: The <=> operator)Claudio Nanni15 Mar
                  • Re: avoiding use of Nulls (was: The <=> operator)Don Read15 Mar
                    • W2008 Server Issues?MCUSA)16 Mar
                      • Re: W2008 Server Issues?David M. Karr16 Mar
            • Re: avoiding use of Nulls (was: The <=> operator)Mattia Merzi14 Mar
        • Re: avoiding use of Nulls (was: The <=> operator)Ray14 Mar
          • Re: avoiding use of NullsAMichel Durand14 Mar
      • Getting single results per (left) record with INNER JOINNigel Peck13 Mar
        • Re: Getting single results per (left) record with INNER JOINNigel Peck13 Mar
          • Re: Getting single results per (left) record with INNER JOINArthur Fuller14 Mar
            • Re: Getting single results per (left) record with INNER JOINNigel Peck14 Mar
              • Re: Getting single results per (left) record with INNER JOINJohan De Meersman15 Mar
                • Re: Getting single results per (left) record with INNER JOINNigel Peck15 Mar
        • Re: Getting single results per (left) record with INNER JOINJoerg Bruehe16 Mar