Re:SQL NULLs Are Weird
by lmm on Friday January 10, 2025 @01:19AM
(#42653120)
What I want is for e.g. "x OR y" where y is NULL (and/or of nullable type) to be an error rather than silently giving surprising results. Just like in a decent programming language I can't do x || y where x and y are of type boolean?, I have to explicitly handle the case where one or other of them is null (or e.g. write x!! || y!! - and that will at still error if either is null rather than silently evaluating to a funny result).
[ Parent
| on HN ]
There are no comments on this comment yet.