On Mon, Oct 5, 2020 at 5:27 PM Martin Davis <mtncl...@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 _______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users