trim_scale

Reduces the value's scale (number of fractional decimal digits) by removing trailing zeroes

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

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

Reduces the value's scale (number of fractional decimal digits) by removing trailing zeroes

Signatures and overloads

trim_scale ( numeric ) → numeric → numeric

Reduces the value's scale (number of fractional decimal digits) by removing trailing zeroes

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:181b03393bccaa82cf0451d8b746b8d50cf80bbdd0c9e04501c17576ce053a09

Text language: en · wiki-repair-20261023:181b03393bccaa82cf0451d8b746b8d50cf80bbdd0c9e04501c17576ce053a09