↑↓ select ↵ open ⌫ change scope Open full search

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

Functions / Mathematical Functions And Operators

scale

Read the PG 18 manual

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

Reading PG 18current·documented in 12 of 27 versions, 9.6 to 20

7.17.27.37.48.08.18.28.38.49.09.19.29.39.49.59.61011121314151617181920

Signatures & examples

scale ( numeric ) → integer
Scale of the argument (the number of decimal digits in the fractional part)
scale(8.4100) → 4
Version history 2
  1. 12 → 13 changed
  2. 9.5 → 9.6 added

Definition snapshot: b7bd9cda · English manual source