postgresql numeric type without trailing zeros

Question

When use numeric type, for example like this numeric(4,2) and if store in him number 1.2, at end of number are adding zeros for filling scale part right? that is result is 1.20

There is possible to save "short" scale as "short"? that is without adding zeros at end ?

Maxim Kolesnikov · Accepted Answer · 2013-04-25 05:59:27Z

4

You shouldn't worry about extra space used for scale part.

According to documentation values of numeric type saved without trailing zeroes:

Numeric values are physically stored without any extra leading or trailing zeroes. Thus, the declared precision and scale of a column are maximums, not fixed allocations. (In this sense the numeric type is more akin to varchar(n) than to char(n).) The actual storage requirement is two bytes for each group of four decimal digits, plus three to eight bytes overhead.

edited Apr 25, 2013 at 5:59

answered Apr 24, 2013 at 16:00

Maxim Kolesnikov

5,1457 gold badges40 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

postgresql numeric type without trailing zeros

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related