Determine postgres numeric max min values

Question

In one of my PostgreSQL table there is an attribute result with datatype Numeric(20,10).

One of its input value can be +/- infinity.

I want to know with the length (20,10) what are the maximum & minimum values.

@CraigRinger, thanks. What I understood from this is max value can be of 10^10. i.e. 9999999999.9999999999 — reiley
– reiley, Commented Oct 16, 2014 at 6:13
((10^20)-1)/(10^10) actually. Because of the fractional part. — Craig Ringer
– Craig Ringer, Commented Oct 16, 2014 at 7:03

Craig Ringer · Accepted Answer · 2014-10-16 07:37:32Z

17

For a numeric of numeric(precision, scale), the limit values are:

+- ((10^precision)-1)/(10^scale)

so for numeric(20,10) that'd be ((10^20)-1)/(10^10) or 9999999999.9999999999 .

Details in the manual.

answered Oct 16, 2014 at 7:37

Craig Ringer

329k83 gold badges742 silver badges820 bronze badges

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

Comments

karim Ífedayo · Accepted Answer · 2023-06-24 10:08:30Z

1

For long decimals, you might run into precision errors in languages like JavaScript. So you can do something like this.

const calcluateDecimalMax = (x: number, y: number): string => {
    const leftCount = x - y
    const rightCount = y
    const leftString = "9".repeat(leftCount)
    const rightString = "9".repeat(rightCount)
    return `${leftString}.${rightString}`
}

console.log(calcluateDecimalMax(25, 9)) // "9999999999999999.999999999"

answered Jun 24, 2023 at 10:08

karim Ífedayo

791 silver badge4 bronze badges

Collectives™ on Stack Overflow

Determine postgres numeric max min values

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related