List:General Discussion« Previous MessageNext Message »
From:Don Read Date:March 15 2009 7:52pm
Subject:Re: avoiding use of Nulls (was: The <=> operator)
View as plain text  
On Sun, 15 Mar 2009 20:19:51 +0100 Claudio Nanni said:

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

> If you control your code, after retrieving the values from the database ,
> you should have something like this:
> 
> if ($row['temperature'] != 9999) { ....this values are reallly good....}
> 
> you just moved the NULL values handling from the database to the
> application.
> 
<more snipage>

> 
> > So instead of thinking that I am an idiot, try using your intelligence and
> > try to understand what I am really talking about!
> >
> 
> Now, if you really want this conversation to be constructive, just reflect
> on this statement:
> Your fake 9999 value for you has the same use of NULL, you just do not like
> the NULL handling syntax.
> 

<snip again>

> If you are wondering who Codd is I can anticipate you that he invented the
> things we are talking about
> (http://en.wikipedia.org/wiki/Edgar_F._Codd)
> 
> 
> Cheers
> 
> Claudio Nanni

And Claudio for the WIN!

-- 
Don Read                                   donread@stripped
     It's always darkest before the dawn. So if you are going to 
     steal the neighbor's newspaper, that's the time to do it.
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