Functions / Mathematical Functions And Operators

trim_scale

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

Reading PG 18current·documented in 8 of 27 versions, 13 to 20

Signatures & examples

trim_scale ( numeric ) → numeric

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

trim_scale(8.4100) → 8.41

Version history 1

Definition snapshot: b7bd9cda · English manual source