I saw there is a round() function that return the closest int from the numeric variable.
But there is no round(x) function that would return the numeric value with x decimal.
For example:
select round(192.4525, 2) -> 192.46
select round(2.3246, 2) -> 2.32
Some doc here:
http://www.postgresql.org/docs/9.1/static/functions-math.html
How well is this supported in other SQL dialects?
There is the same function in MySql:
http://dev.mysql.com/doc/refman/5.0/fr/mathematical-functions.html
Also in Oracle:
http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions135.htm
Added to MathExpressions
Released in 3.2.2
Most helpful comment
Added to
MathExpressions