Rounding strategy of the 'round' function - Mailing list pgsql-docs

From Rudolph Froger
Subject Rounding strategy of the 'round' function
Date
Msg-id 84366276-5142-da72-b5c3-0b3bab186ff5@dreamsolution.nl
Whole thread Raw
List pgsql-docs
Hi,

The 'round' mathematical function documentation doesn't specify its 
rounding strategy. If this would be documented then users can rely on 
its rounding behavior. For double precision the rounding probably 
depends on your platform. For numeric the function seems to round to 
nearest with ties going away from zero (sometimes referred to as "round 
half up). 6.5 -> 7.0 and -6.5 -> -7.0.

https://www.postgresql.org/docs/current/functions-math.html

Kind regards, Rudolph



pgsql-docs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: "there is no way to insert less than one row"
Next
From: PG Doc comments form
Date:
Subject: PL/Tcl - examples not working