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

floating point output

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 single select's output) and the droppin