3 ms·
Plenty of languages have types that let you ask those kind of operations in a nice way. E.g. in Haskell you'd do traverse (flip when (putStrLn "James and J
by lmm 7y ago
Plenty of languages have types that let you ask those kind of operations in a nice way. E.g. in Haskell you'd do
traverse (flip when (putStrLn "James and Jane have same car color")) $
liftA2 == james.car.colour jane.car.colour
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.