val – An arbitrary precision calculator language written in Rust
Why 5.0 / 2 returns 2.5000000000000000 (scale of 16) instead of 2.5 (scale of 1)? Fiddle select 5...
https://stackoverflow.com/questions/79408926/why-5-0-2-returns-2-5000000000000000-scale-of-16-instead-of-2-5-scale-of-1
#sql #postgresql #precision #numeric #arbitrary-precision
Event Attributes
https://stackoverflow.com/questions/79408926/why-5-0-2-returns-2-5000000000000000-scale-of-16-instead-of-2-5-scale-of-1
#sql #postgresql #precision #numeric #arbitrary-precision
Event Attributes
Stack OverflowWhy 5.0 / 2 returns 2.5000000000000000 (scale of 16) instead of 2.5 (scale of 1)?Fiddle
select 5.0 / 2
, pg_typeof(5.0 / 2);
pg_typeof
2.5000000000000000
numeric
Why the result is 2.5000000000000000?
When we insert 2.5 into a numeric column or select 2.5 from a numeric ...