Re: floating point output

On 2019-09-09 01:03:06 -0400, Tom Lane wrote: > Rob Sargent writes: > > Below I show a floating point column from a recent query. > > > Here's my guess at what's happening in the formatting: > > 1) scientific notation if smaller than 1.0e-04 (I’m not in the > > very-much-larger-than-one worl

Re: floating point output

Rob Sargent writes: > Below I show a floating point column from a recent query. > Here's my guess at what's happening in the formatting: > 1) scientific notation if smaller than 1.0e-04 (I’m not in the > very-much-larger-than-one world) > 2) 15 digits after the most signicant 0 > 3) remo

Re: floating point output

> On Sep 5, 2019, at 7:32 AM, Rob Sargent wrote: > > > >> On Sep 4, 2019, at 9:14 PM, Adrian Klaver wrote: >> >>> On 9/4/19 5:23 PM, Rob Sargent wrote: >>> I've found the description of floating point types (here >>>

Re: floating point output

> On Sep 4, 2019, at 9:14 PM, Adrian Klaver wrote: > >> On 9/4/19 5:23 PM, Rob Sargent wrote: >> I've found the description of floating point types (here >> ), >> but I'm looking for the rationale of the output format,

Re: floating point output

On Thu, Sep 5, 2019 at 6:14 AM Adrian Klaver wrote: > Some examples would help explain your concerns. I guess the problem is with extra_float_digits. If greater then zero, the string representation of a real is at its minimum, that is only significative digits are there: restoredb=# set extra_fl

Re: floating point output

On 9/4/19 5:23 PM, Rob Sargent wrote: I've found the description of floating point types (here ), but I'm looking for the rationale of the output format, particularly with respect to total digits presented (variable in a s