Re: Lossless transmission of double precision floating point

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Michael J(dot) Baars" <mjbaars1977(dot)pgsql(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Lossless transmission of double precision floating point
Date: 2025-07-18 14:12:17
Message-ID: 1853147.1752847937@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Michael J. Baars" <mjbaars1977(dot)pgsql(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tender Wang 2025-07-18 14:33:50 Re: postgres_fdw could deparse ArrayCoerceExpr
Previous Message Tom Lane 2025-07-18 14:09:53 Re: Upgrade from Fedora 40 to Fedora 42, or from PostgreSQL 16.3 to PostgreSQL 16.9