{"Entry":{"collection":"func","key":"trim-scale","name":"trim_scale","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"13"}],"content_hash":"cb5ec413788207ae66949e8f668cd713f1c0f57209020db229e7279e1cdc833f","derived_content_hash":"d235068dc142c4a1840ef0857815c5b5db6148907ef2cf7526e60dae4f708f30","documentation_refresh":{"batch":"20261113","original_source_rev":"wiki-repair-20261023:181b03393bccaa82cf0451d8b746b8d50cf80bbdd0c9e04501c17576ce053a09","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"first_version":"13","group":"math","group_label":"Mathematical Functions And Operators","groups":["math"],"imported_at":"2026-09-27T17:57:28.289998+08:00","last_version":"20","name":"trim_scale","name_key":"trim_scale","position":2053,"present_in":["13","14","15","16","17","18","19","20"],"repair_provenance":{"original_source_revision":"b7bd9cda","receipt_sha256":"c31ad7f919d7a2561975480b5ca74593e94afa89950a263b29a06c96ff13a904","repair":"wiki-repair-20261023"},"signature":"trim_scale ( numeric ) → numeric","signature_count":1,"slug":"trim-scale","source_rev":"wiki-repair-20261023:181b03393bccaa82cf0451d8b746b8d50cf80bbdd0c9e04501c17576ce053a09","summary":"Reduces the value's scale (number of fractional decimal digits) by removing trailing zeroes","summary_zh":""}},"Definition":{"Collection":"func","Key":"trim-scale","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"trim-scale","SourceRevision":"wiki-repair-20261023:181b03393bccaa82cf0451d8b746b8d50cf80bbdd0c9e04501c17576ce053a09","Facts":{"description":"Reduces the value's scale (number of fractional decimal digits) by removing trailing zeroes","description_html":"Reduces the value's scale (number of fractional decimal digits) by removing trailing zeroes","description_zh":"通过移除尾随零来减少值的小数位数","description_zh_html":"通过移除尾随零来减少值的小数位数","doc":{"anchor":"FUNCTIONS-MATH-FUNC-TABLE","file":"functions-math.html","sha256":"80bdcd3a2c7112aadf400e832cc7c8ee55e389d9b3c12e767c3fbb2b3364ef7b","slug":"18"},"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"},"group":"math","group_label":"数学函数和操作符","lang":"en","layout":"table-new","pages":["functions-math.html"],"prose_only":false,"signatures":[{"description":"Reduces the value's scale (number of fractional decimal digits) by removing trailing zeroes","description_html":"Reduces the value's scale (number of fractional decimal digits) by removing trailing zeroes","description_zh":"通过移除尾随零来减少值的小数位数","description_zh_html":"通过移除尾随零来减少值的小数位数","examples":[{"expr":"trim_scale(8.4100)","result":"8.41"}],"html":"\u003ccode class=\"function\"\u003etrim_scale\u003c/code\u003e ( \u003ccode class=\"type\"\u003enumeric\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003enumeric\u003c/code\u003e","returns":"numeric","text":"trim_scale ( numeric ) → numeric","zh_from":"same-version-manual"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/functions-math.html","sha256":"b5f393c537ea29401867ea8b97292650ee67b0dd9e8cde535aae77bc594b3736"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-MATH-FUNC-TABLE","file":"functions-math.html","sha256":"80bdcd3a2c7112aadf400e832cc7c8ee55e389d9b3c12e767c3fbb2b3364ef7b","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"trim-scale","SourceDatabase":"center","Version":"18","Locale":"en","Title":"trim_scale","Summary":"Reduces the value's scale (number of fractional decimal digits) by removing trailing zeroes","BodyHTML":"Reduces the value\u0026#39;s scale (number of fractional decimal digits) by removing trailing zeroes","SourceRevision":"wiki-repair-20261023:181b03393bccaa82cf0451d8b746b8d50cf80bbdd0c9e04501c17576ce053a09","ContentHash":"eb94d54825b6de7b672eb41f4552b3f64e63efff77254fc0a39b797b064f6ba7","Payload":{"description":"Reduces the value's scale (number of fractional decimal digits) by removing trailing zeroes","description_html":"Reduces the value's scale (number of fractional decimal digits) by removing trailing zeroes","signatures":[{"description":"Reduces the value's scale (number of fractional decimal digits) by removing trailing zeroes","description_html":"Reduces the value's scale (number of fractional decimal digits) by removing trailing zeroes","description_zh":"通过移除尾随零来减少值的小数位数","description_zh_html":"通过移除尾随零来减少值的小数位数","examples":[{"expr":"trim_scale(8.4100)","result":"8.41"}],"html":"\u003ccode class=\"function\"\u003etrim_scale\u003c/code\u003e ( \u003ccode class=\"type\"\u003enumeric\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003enumeric\u003c/code\u003e","returns":"numeric","text":"trim_scale ( numeric ) → numeric","zh_from":"same-version-manual"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"cb657eb5834ee84298850bce6bcd3442b9698ea4c60849a2f95f937b88c39e4d","Text":"trim_scale ( numeric ) → numeric","Returns":"numeric","Payload":{"description":"Reduces the value's scale (number of fractional decimal digits) by removing trailing zeroes","description_html":"Reduces the value's scale (number of fractional decimal digits) by removing trailing zeroes","description_zh":"通过移除尾随零来减少值的小数位数","description_zh_html":"通过移除尾随零来减少值的小数位数","examples":[{"expr":"trim_scale(8.4100)","result":"8.41"}],"html":"\u003ccode class=\"function\"\u003etrim_scale\u003c/code\u003e ( \u003ccode class=\"type\"\u003enumeric\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003enumeric\u003c/code\u003e","returns":"numeric","text":"trim_scale ( numeric ) → numeric","zh_from":"same-version-manual"}}],"Spellings":null,"SQLState":null,"Evidence":null}