Re:SELECT wat FROM sql
by lmm on Monday April 27, 2020 @08:50AM
(#22995302)
Plenty of languages have types that let you ask those kind of operations in a nice way. E.g. in Haskell you'd do
The problem isn't that SQL supports tri-state logic, it's that it gives you no way of opting out of it. Over 90% of the time a given value should never be null, but there's no way to put SQL into a mode where a null in a given intermediate stage is an error. Instead it will silently give you a strange answer with no indication that anything went wrong.
[ Parent
| on HN ]
There are no comments on this comment yet.