<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
<pre>Hi,<br><br>I can't figure out why this is happening:<br><br>This works, returning true:<br>SELECT Intersects(<br>GeomFromEWKT('MULTILINESTRING((-26.9599999999939 -29.97 1 0,-26.9399999999976 -29.99 2 0),(-25.8599999999937 -29.97 1 0,-26.9399999999976 -29.99 2 0))'), <br> GeomFromEWKT('POINT(-26.9599999999939 -29.97 1 0)')) ;<br><br>If I select the same as geometries, it returns false<br>SELECT ST_Intersects(<br> <br>(select geom1 from tab), <br><br> (select geom2 from tab)) ;<br><br><br>Weird thing is, <br> select ST_DISTANCE (geom1, geom2)<br>returns 3.51700710773038e-14<br><br>This behavior is not consistent - sometimes ST_INTERSECTS returns true correctly.<br><br>Can anyone suggest what might be the problem here?<br><br>Thanks,<br>Satish<br></pre> <br /><hr />New Windows 7: Find the right PC for you. <a href='http://windows.microsoft.com/shop' target='_new'>Learn more.</a></body>
</html>