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 [email protected]
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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
