[postgis-users] Different hex POINT representation but the same coordinates?

[rmrodriguez at carto.com]

On Mon, Oct 5, 2020 at 5:27 PM Martin Davis <mtnclimb at gmail.com> wrote:
>
> PostGIS WKT output does overly-aggressive rounding, IMO.

Not anymore (changed in 3.1+):

template_postgis=# SELECT
ST_AsText(ST_GeomFromWKB('\x01010000000ad7a3f0735727c13e0ad7a3ae0c30c1'));
              st_astext
---------------------------------------
POINT(-764857.97 -1051822.6400000001)
(1 row)

template_postgis=# SELECT
ST_AsText(ST_GeomFromWKB('\x01010000000ad7a3f0735727c13e0ad7a3ae0c30c1'));
              st_astext
---------------------------------------
POINT(-764857.97 -1051822.6400000001)
(1 row)

And what's best, it won't ever try to return 150 decimal digits (or
30+ like in Komzpa's message) since they aren't meaningful.

-- 
Raúl Marín Rodríguez
carto.com