Details
-
New Feature
-
Status: Resolved
-
Minor
-
Resolution: Fixed
-
None
-
None
Description
Function Definition
INT8 round(value FLOAT8) INT8 floor(value FLOAT8) INT8 ceil(value FLOAT8)
Example
round
select round(5.1) => 5 select round(5.5) => 6 select round(5.6) => 6 select round(-5.1) => -5 select round(-5.5) => -6 select round(-5.6) => -6
floor
select round(5.1) => 5 select round(5.5) => 5 select round(-5.1) => -6 select round(-5.6) => -6
ceil
select round(5.1) => 6 select round(5.5) => 6 select round(-5.1) => -5 select round(-5.6) => -5