round

Rounds to nearest integer. For numeric, ties are broken by rounding away from zero. For double precision, the tie-breaking behavior is platform dependent, but “round to nearest even” is the most common rule.

English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

group: math
group label: 数学函数和操作符
lang: en
layout: table-new
pages: functions-math.html
prose only: false

Definition PG 18

Rounds to nearest integer. For numeric, ties are broken by rounding away from zero. For double precision, the tie-breaking behavior is platform dependent, but “round to nearest even” is the most common rule.

Signatures and overloads

round ( numeric ) → numeric → numeric

round ( double precision ) → double precision → double precision

round ( v numeric, s integer ) → numeric → numeric

Rounds v to s decimal places. Ties are broken by rounding away from zero.

Compare versions

Complete source facts

documentation revision

{"inputs":[{"file":"functions-math.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"80bdcd3a2c7112aadf400e832cc7c8ee55e389d9b3c12e767c3fbb2b3364ef7b","version":"18.7"},{"file":"functions-math.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"b48c7e1d8abf0f030ad0ef2aa1403db7015a96af265d49a15eaa2f1945a13a5f","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:eb65ad21f81ddd3f9419e51ff13bbd6c2ac61b25bf5a0d8fd3f4917e23fe67fd

Text language: en · wiki-repair-20261023:eb65ad21f81ddd3f9419e51ff13bbd6c2ac61b25bf5a0d8fd3f4917e23fe67fd