On 10/10/2018 08:23 AM, Sandro Santilli wrote: > On Wed, Oct 10, 2018 at 10:07:20AM -0300, Agustin Ignacio Genoves wrote: > >> when I compared two identical geometries with the function st_equals () it >> returns false. I give details of the geometries and the query. > When you print the geometries in WKT form you loose precision > (due to the limited number of decimal digits we print). > > Get an HEXWKB representation of those two geometries and I bet you'll > find a difference. > > --strk; Why would the HEXWKB be different if both geometries were created with identical calls to ST_GeometryFromText?
Any any case, the select statement returns true for me on: PostgreSQL 9.6.10 on x86_64-pc-linux-gnu, compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit | 2.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1 _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
