ROUND function produces too many decimal places

[debfawn]

Hello,

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)

I want the result to be 0.7

[JimKnicely]

Check out the post:

http://www.vertica-forums.com/viewtopic.php?f=63&t=903

Code: Select all

dbadmin=> select round(48/67, 1.0);
 round
-------
   0.7
(1 row)

[debfawn]

Thanks, Jim. Sorry, I should have searched the site before posting