News for hackers. Stuff that matters.

A comment on Is it time to stop using sentinel values for null / “NA” values?. Parent comment

Re:Is it time to stop using sentinel values for null / “NA” ... by arthurjj on Monday June 05, 2023 @12:55PM (#36199228)
>the summation works fine

This is only true if that summation is not used or compared anywhere else which isn't usually the case. For example if in sql you are reporting the SUM(column_A)/ SUM(column_B) and one column can be null without the other one being null you're likely reporting the wrong number

[ Parent | on HN ]
Re:Is it time to stop using sentinel values for null / “NA” ... by cratermoon on Monday June 05, 2023 @12:57PM (#36199271)
So you're saying if you don't consistently use the same value to represent the value, you get incorrect results?
[ Parent | on HN ]