[postgis-devel] Inconsistencies in text output

Sandro Santilli strk at kbt.io
Mon Apr 20 09:02:36 PDT 2020


On Fri, Apr 17, 2020 at 06:35:42PM +0200, rmrodriguez at carto.com wrote:

> I wanted a way to ensure there would be no loss of information when
> doing storage1 > wkt/geojson -> storage2 

We've always had this problem with;

    storage1 > wkt > storage2

Enought that we invented HEXEWKB to deal with it.
Any decimal representation of a floating point number
will have this problem, as not all numbers that can be
represented by a floating point number can fit on a
screen.

--strk;


More information about the postgis-devel mailing list