Contents
scale()
A function returning the scale of the argument
scale()
is a system function which returns the scale of the argument (the number of decimal digits in the fractional part).
scale()
was added in PostgreSQL 9.6.
Usage
scale ( numeric ) → integer
From PostgreSQL 13, the function min_scale() is available, which does the same thing but removes any trailing zeroes.
Change history
- PostgreSQL 9.6
- added (commit abb17339)
Examples
Execution examples for scale()
:
postgres=# SELECT scale(1.2300); scale ------- 4 (1 row) postgres=# SELECT scale(1.23); scale ------- 2 (1 row) postgres=# SELECT scale(1.0); scale ------- 1 (1 row) postgres=# SELECT scale(1); scale ------- 0 (1 row)
References
- PostgreSQL documentation: Mathematical Functions