Timeline for How can I explain the difference between NULL and zero?
Current License: CC BY-SA 3.0
50 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 22, 2022 at 14:34 | comment | added | β.εηοιτ.βε | Someone somehow made a meme for this reddit.com/r/ProgrammerHumor/comments/tivhan/… | |
| Apr 21, 2015 at 8:48 | history | edited | yannis | edited tags | |
| Jul 8, 2013 at 19:55 | review | Suggested edits | |||
| Jul 8, 2013 at 20:07 | |||||
| Jan 24, 2013 at 6:55 | comment | added | Daniel B | It's not perhaps the most correct analogy, but I always explain it as: think of a NULL as an "unknown" or "I don't know". How much is 5 plus 2 plus I don't know? I don't know. | |
| Feb 16, 2012 at 23:00 | vote | accept | O.O | ||
| Feb 14, 2012 at 20:15 | answer | added | JustinC | timeline score: 1 | |
| Feb 14, 2012 at 18:08 | history | notice added | yannis | Needs detailed answers | |
| Feb 14, 2012 at 18:00 | answer | added | JSR | timeline score: 0 | |
| Feb 14, 2012 at 17:29 | answer | added | Jim G. | timeline score: 0 | |
| Feb 14, 2012 at 13:44 | comment | added | JNK | I can't answer now that it's protected, but I always explain that NULL is a state, not a value - it means you don't know the value. For SQL I normally use the party analogy to demonstrate. | |
| Feb 14, 2012 at 12:44 | history | protected | CommunityBot | ||
| Feb 14, 2012 at 11:45 | answer | added | Scott Whitlock | timeline score: 0 | |
| Feb 14, 2012 at 11:25 | answer | added | Dibbeke | timeline score: -1 | |
| Feb 14, 2012 at 9:12 | comment | added | user25446 | By analogy, 0 Degrees temperature, and No temperature reading are different situations... | |
| Feb 14, 2012 at 6:27 | answer | added | Michael | timeline score: -2 | |
| Feb 14, 2012 at 2:32 | comment | added | detly | @ZJR - so display the message in red below the box. Point is, "NULL" or an empty string have about as much use in a UI as the memory address of an object. | |
| Feb 14, 2012 at 2:12 | comment | added | ZJR | @Craig N/A if the text field is really small :) | |
| Feb 14, 2012 at 1:03 | comment | added | detly | @Craig's is the real answer. | |
| Feb 13, 2012 at 23:47 | history | tweeted | twitter.com/#!/StackProgrammer/status/169206175013941249 | ||
| Feb 13, 2012 at 22:27 | answer | added | JeffO | timeline score: 1 | |
| Feb 13, 2012 at 22:06 | answer | added | Nir Alfasi | timeline score: 1 | |
| S Feb 13, 2012 at 22:01 | answer | added | Vasiliy Sharapov | timeline score: 1 | |
| S Feb 13, 2012 at 22:01 | history | made wiki | Post Made Community Wiki by Vasiliy Sharapov | ||
| Feb 13, 2012 at 21:45 | answer | added | Spencer Rathbun | timeline score: -1 | |
| Feb 13, 2012 at 21:31 | answer | added | Jonathan Maddison | timeline score: 4 | |
| Feb 13, 2012 at 21:27 | answer | added | Jim | timeline score: 7 | |
| Feb 13, 2012 at 21:24 | answer | added | dr jimbob | timeline score: 1 | |
| Feb 13, 2012 at 21:18 | answer | added | Michael Haren | timeline score: 20 | |
| Feb 13, 2012 at 21:16 | answer | added | Bryan B | timeline score: 3 | |
| Feb 13, 2012 at 21:08 | history | edited | Thomas Owens♦ | CC BY-SA 3.0 | Cleaned up title |
| S Feb 13, 2012 at 21:08 | history | suggested | Cloudy | CC BY-SA 3.0 | Cleaned up title |
| Feb 13, 2012 at 21:04 | review | Suggested edits | |||
| S Feb 13, 2012 at 21:08 | |||||
| Feb 13, 2012 at 20:18 | answer | added | back2dos | timeline score: 12 | |
| Feb 13, 2012 at 20:15 | answer | added | Falcon | timeline score: 8 | |
| Feb 13, 2012 at 20:05 | comment | added | Craig | Change the textbox to say "Data unavailable" instead of the empty string. | |
| Feb 13, 2012 at 20:03 | answer | added | Tom Squires | timeline score: 4 | |
| Feb 13, 2012 at 20:02 | answer | added | Eric King | timeline score: 38 | |
| Feb 13, 2012 at 20:00 | answer | added | Dave Wise | timeline score: 174 | |
| Feb 13, 2012 at 20:00 | answer | added | Jonathan Rich | timeline score: 4 | |
| Feb 13, 2012 at 19:57 | history | edited | O.O | CC BY-SA 3.0 | added 142 characters in body |
| Feb 13, 2012 at 19:56 | answer | added | KeithS | timeline score: 104 | |
| Feb 13, 2012 at 19:50 | answer | added | HLGEM | timeline score: 1 | |
| Feb 13, 2012 at 19:49 | history | edited | O.O | CC BY-SA 3.0 | edited body |
| Feb 13, 2012 at 19:44 | answer | added | Morons | timeline score: 5 | |
| Feb 13, 2012 at 19:43 | comment | added | O.O | @S.Lott - OK, I added the language. | |
| Feb 13, 2012 at 19:43 | history | edited | O.O | CC BY-SA 3.0 | edited tags |
| Feb 13, 2012 at 19:42 | comment | added | Karl Bielefeldt | In this particular case the result is undefined either way. By the way, the formula should have new value - old value, not the other way around. | |
| Feb 13, 2012 at 19:42 | comment | added | James McLeod | Perhaps the real question is, how should NULL be interpreted? And the answer is that, typically, if one of the values is NULL, the formula does not apply. | |
| Feb 13, 2012 at 19:40 | comment | added | S.Lott | "How would I explain the difference"? In which language? Some languages throw (or raise) an exception. Some will return a NULL result. Some depend on the details of how NULL is implemented. You have to be much more specific. | |
| Feb 13, 2012 at 19:35 | history | asked | O.O | CC BY-SA 3.0 |