Re: NumericShort vs NumericLong format

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: NumericShort vs NumericLong format
Дата
Msg-id CAKFQuwbUxr-u2BT2PQ4Q_n_o0DieipneHQE+VEPML96bnR3HDQ@mail.gmail.com
обсуждение исходный текст
Ответ на NumericShort vs NumericLong format  (Amin <amin.fallahi@gmail.com>)
Ответы Re: NumericShort vs NumericLong format  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Дерево обсуждения
I'll give this a go as a learning exercise for myself...

On Mon, Mar 6, 2023 at 8:47 PM Amin <amin.fallahi@gmail.com> 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

(the three constants are decimal 63, 63, and -64 respectively)
- What the precision and scale values should be for pgsql to use the long format? Is there a threshold?


Ones that cause the linked-to test to return false I suppose.

David J.

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"?

https://github.com/postgres/postgres/blob/cf96907aadca454c4094819c2ecddee07eafe203/src/backend/utils/adt/numeric.c#L121

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Julien Rouhaud
Дата:
Сообщение: Re: Combine pg_walinspect till_end_of_wal functions with others
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Raising the SCRAM iteration count