Re: Lossless transmission of double precision floating point - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Lossless transmission of double precision floating point
Date
Msg-id 1853147.1752847937@sss.pgh.pa.us
Whole thread Raw
In response to Lossless transmission of double precision floating point  ("Michael J. Baars" <mjbaars1977.pgsql@gmail.com>)
List pgsql-hackers
"Michael J. Baars" <mjbaars1977.pgsql@gmail.com> writes:
> I receive data from a data provider on a daily basis, and noticed how they
> use fixed type floating point in text mode, to transmit data. As you might
> know, this type of transmission is not lossless.

It is if you use enough decimal digits.  Are you sure you're not
inventing something to worry about?

            regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Upgrade from Fedora 40 to Fedora 42, or from PostgreSQL 16.3 to PostgreSQL 16.9
Next
From: Tender Wang
Date:
Subject: Re: postgres_fdw could deparse ArrayCoerceExpr