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

Michal Seidl michal.seidl at gmail.com
Mon Oct 5 08:21:17 PDT 2020


Hello I have two points with different HEX representation but the same 
WKT representation? I do not know the binary representation in detail.

The difference in HEX is somewhere in th middle "d" versus "e" value

SELECT 
ST_AsEWKT(ST_GeomFromWKB('\x01010000000ad7a3f0735727c13e0ad7a3ae0c30c1'));

SELECT 
ST_AsEWKT(ST_GeomFromWKB('\x01010000000ad7a3f0735727c13d0ad7a3ae0c30c1'));

SELECT ST_GeomFromWKB('\x01010000000ad7a3f0735727c13e0ad7a3ae0c30c1') = 
ST_GeomFromWKB('\x01010000000ad7a3f0735727c13d0ad7a3ae0c30c1');

So what is different?

Michal


More information about the postgis-users mailing list