News for hackers. Stuff that matters.
Re:SQL NULLs Are Weird by gigatexal on Friday January 10, 2025 @03:20PM (#42659679)
How is that different than “anything”?

If I’m comparing a value of type date to a null I still think it works as it should if value is “unknown”. What greater insight or context do we have if it’s a small-int null?

Re:SQL NULLs Are Weird by mulmen on Friday January 10, 2025 @03:58PM (#42660127)
> How is that different than “anything”?

Because the possible values are known.

> What greater insight or context do we have if it’s a small-int null?

The insight is that null is not a value. It’s not a smallint or a boolean or a date. It’s the absence of a possible value. The only way to see a null as tri-state is to conflate it with a nullable boolean. This is an incorrect mental model which leads to confusion.

Re:SQL NULLs Are Weird by rawgabbit on Friday January 10, 2025 @08:21PM (#42662411)
Suppose you have table with two columns to represent a classroom’s exam scores. It has the columns student_id (varchar) and score (int).

If a student is sick and has not taken the exam, yes you could enter -99 to represent they did not take the test. But if you want to find the class average, you would have to do something like this:

select average(case when score =-99 then null else score end) as class_avg from …

Or you could have entered null to begin with.