↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Functions

scale

Scale of the argument (the number of decimal digits in the fractional part)

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

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

Definition PG 18

Scale of the argument (the number of decimal digits in the fractional part)

Signatures and overloads

scale ( numeric ) → integer → integer
Scale of the argument (the number of decimal digits in the fractional part)

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

Full definition and evidence JSON

Definition sources

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

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