> On Sep 4, 2019, at 9:14 PM, Adrian Klaver <adrian.kla...@aklaver.com> wrote:
>
>> On 9/4/19 5:23 PM, Rob Sargent wrote:
>> I've found the description of floating point types (here
>> <https://www.postgresql.org/docs/10/datatype-numeric.html#DATATYPE-FLOAT>),
>> 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 dropping of a trailing zero (to some implying a loss of precision). Is
>> the code my only guide here?
>
> Some examples would help explain your concerns.
>
> Bottom line, if you want precision use numeric.
>
>
>
When at my desk I’ll give example. Actual precision is not the issue. Purely
cosmetics.