Hi. I've a question about geometry constructors.<br><br>I've a table with a geometry column for storing points with 14024 rows, and srid -1. Of those rows, there are 27 in wich<br><br>the_geom ~= geometryFromText(asText(the_geom),-1)
<br><br>returns false.<br><br>If I make<br><br>select the_geom, geometryFromText(asText(the_geom),-1) in one of those rows, with geometry POINT(573811.278250325 6137116.18770014), for example, I get<br><br>                 the_geom                                                      |              geometryfromtext
<br>---------------------------------------------------------------------+--------------------------------------------------------------------<br> 01010000009AD3768EE68221417147030C47695741   01010000009CD3768EE68221417347030C47695741
<br><br>The only difference, corresponding to the digit in the 12 position, seems to be part of the 8 byte group storing the X coordinate of the point.<br><br>But if I make<br><br>select the_geom, geomFromWKB(asBinary(the_geom),-1)
<br><br>of the same row, I get  01010000009AD3768EE68221417147030C47695741 in both cases.<br><br>Does anyone know the reason of this difference? Is it due to a difference between the precision obtained in the asText representation and that of the 8 byte double? We need to work with the geometryFromText constructor and text representations of geometries, so I would be very gratefull If someone could explain this difference.
<br><br>Thanks very much,<br>Antonio Grassi<br><br>