{"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","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"],"signature":"trim_scale ( numeric ) → numeric","signature_count":1,"slug":"trim-scale","source_rev":"b7bd9cda","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":"b7bd9cda","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","slug":"18"},"group":"math","group_label":"Mathematical Functions And Operators","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":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-MATH-FUNC-TABLE","file":"functions-math.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"trim-scale","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"trim_scale","Summary":"通过移除尾随零来减少值的小数位数","BodyHTML":"通过移除尾随零来减少值的小数位数\u003cpre\u003etrim_scale ( numeric ) → numeric\u003c/pre\u003e通过移除尾随零来减少值的小数位数","SourceRevision":"ca936764","ContentHash":"bcc4c6f55467ab91cd4d141d3c798957a1b450766cff5e8e94f191df312eda21","Payload":{"description_zh":"通过移除尾随零来减少值的小数位数","description_zh_html":"通过移除尾随零来减少值的小数位数","signatures":[{"description_zh":"通过移除尾随零来减少值的小数位数","description_zh_html":"通过移除尾随零来减少值的小数位数","returns":"numeric","text":"trim_scale ( numeric ) → numeric","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","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":""}}],"Spellings":null,"SQLState":null,"Evidence":null}