News for hackers. Stuff that matters.
Re:SQL NULLs Are Weird by empthought on Friday January 10, 2025 @05:16PM (#42660892)
> That's the thing that's being treated as FALSE. That UNKNOWN. Not the value of NULL itself.

No, it's being treated as UNKNOWN, and the semantics of SELECT...WHERE only returns rows where the value of the condition is TRUE.

I think you need to look into https://en.wikipedia.org/wiki/Negation_as_failure

There are no comments on this comment yet.