| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Amin <amin(dot)fallahi(at)gmail(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: NumericShort vs NumericLong format |
| Date: | 2023-03-07 04:46:42 |
| Message-ID: | CAKFQuwbUxr-u2BT2PQ4Q_n_o0DieipneHQE+VEPML96bnR3HDQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)fallahi(at)gmail(dot)com> wrote:
>
> - How can I determine which format will be used for a numeric type?
>
(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"?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2023-03-07 04:53:00 | Re: Raising the SCRAM iteration count |
| Previous Message | Julien Rouhaud | 2023-03-07 04:42:20 | Re: Combine pg_walinspect till_end_of_wal functions with others |