News for hackers. Stuff that matters.
Re:SQL NULLs Are Weird by hobs on Friday January 10, 2025 @08:29AM (#42655428)
No, it's not those other things, that's just using the tool incorrectly. A NULL is definitely "we dont know", not false, not N/A, especially not any known value.
Re:SQL NULLs Are Weird by swiftcoder on Friday January 10, 2025 @09:39AM (#42655922)
Except in every other programming language with a null, null is the definite absence of something
Re:SQL NULLs Are Weird by hobs on Friday January 10, 2025 @05:09PM (#42660834)
Sure, and we're talking about SQL nulls in this context, which is why I am strict in my definition.
Re:SQL NULLs Are Weird by dominicrose on Monday January 13, 2025 @04:19AM (#42681566)
Yes and I think that Clojure handles nil pretty well, and it's a functional programming language like SQL. It's also interesting to see that Typescript has added an unknown type. So something that's a value in SQL (null being unknown) is a type in TS.