Re: NumericShort vs NumericLong format

2024-04-09 Thread Ole Peder Brandtzæg
On Tue, Mar 07, 2023 at 12:15:27AM -0500, Tom Lane wrote: > "David G. Johnston" writes: > > As an aside, for anyone more fluent than I who reads this, is the use of > > the word "dynamic scale" in this code comment supposed to be "display > > scale"? > >

Re: NumericShort vs NumericLong format

2023-03-06 Thread Tom Lane
"David G. Johnston" writes: > As an aside, for anyone more fluent than I who reads this, is the use of > the word "dynamic scale" in this code comment supposed to be "display > scale"? >

Re: NumericShort vs NumericLong format

2023-03-06 Thread David G. Johnston
I'll give this a go as a learning exercise for myself... On Mon, Mar 6, 2023 at 8:47 PM Amin wrote: > > - How can I determine which format will be used for a numeric type? > https://github.com/postgres/postgres/blob/cf96907aadca454c4094819c2ecddee07eafe203/src/backend/utils/adt/numeric.c#L491

NumericShort vs NumericLong format

2023-03-06 Thread Amin
Hi, - How can I determine which format will be used for a numeric type? - What the precision and scale values should be for pgsql to use the long format? Is there a threshold?