[postgis-users] Geometry problems

[Jim Klassen]

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