| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | sebastien(dot)clement(at)canada(dot)ca, pgsql-docs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: decimal digits precision for real and double precision types |
| Date: | 2018-08-07 22:54:26 |
| Message-ID: | 20180807225426.GA19156@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
On Tue, Jul 17, 2018 at 07:15:41PM +0000, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/10/static/datatype-numeric.html
> Description:
>
> In table 8.2 for numeric types, when the documentation states "6 decimal
> digits precision" for the real type, we are talking about 6 digits after the
> decimal point or 6 digits in total (before and after)?
Well the number is stored as a mantissa and exponent, so it is 6
mantissa digits plus an exponent from 1E-37 to 1E+37.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2018-08-08 02:06:55 | Re: Document the limit on the number of parameters |
| Previous Message | Jonathan S. Katz | 2018-08-07 22:45:18 | Re: how to modify the navfooter |