Mega Code Archive

 

Categories / PostgreSQL / Math Functions

 

Round(x, s)

postgres=# postgres=# -- round(x, s): Returns the value of x, optionally rounded to s decimal places postgres=# SELECT round(1.4949, 1) AS one_digit_scale, postgres-#        round(1.4949, 3) AS three_digit_scale, postgres-#        round(1.4949, 10) AS ten_digit_scale, postgres-#        round(1.4949, 0) AS rounded;  one_digit_scale | three_digit_scale | ten_digit_scale | rounded -----------------+-------------------+-----------------+---------              1.5 |             1.495 |    1.4949000000 |       1 (1 row) postgres=#