Oops... Something went wrong. Why did we get such an odd result?
height columns have a
real data type, which is a floating point number. The internal representation is binary arithmetic, which means not all decimals can be represented precisely. Therefore, any computations are not performed exactly, as we can see.
What can be done about it? Nothing! That's the way binary arithmetic works.
If you need exact computations, use
money (for currency) data types. When dealing with money values, always use
money data types. Floating point numbers are for "scientific" computations on various measurements, like