Why does the ROUND function return so many decimal places when I round to 1 decimal place?
Example:
Code: Select all
dbadmin=> select round(48/67, 1);
round
----------------------
0.700000000000000000
(1 row)
Moderator: NorbertKrupa
Code: Select all
dbadmin=> select round(48/67, 1);
round
----------------------
0.700000000000000000
(1 row)
Code: Select all
dbadmin=> select round(48/67, 1.0);
round
-------
0.7
(1 row)