List:General Discussion« Previous MessageNext Message »
From:michael Date:March 14 2009 7:23pm
Subject:Re: avoiding use of Nulls (was: The <=> operator)
View as plain text  
Claudio Nanni wrote:

> Hi everybody I want to join as well.
>
>
> The question is: "Will I allow a record to contain a 'non-informative'
> field
> ?"

No! thats not the question!

> [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.
>

No I would not allow this -9999 value to be viewed by the end user. And
you guys take a hypothetical example and think I want to use that
everywhere.

My point is about using null or not.

In a single data, obviously there will some data required, and some data
optional, and I am not talking about the required data, I am talking about
the optional data, and that null is the worst choice for an initial value.

This is from an application design perspective, not while you a creating a
table or constructing an insert statement.

So instead of thinking that I am an idiot, try using your intelligence and
try to understand what I am really talking about!


Mike.

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