<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
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>
(select geom1 from tab), <br>
(select geom2 from tab)) ;<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>What is the problem here.<br><br>Thanks,<br>Satish<br> <br /><hr />http://windows.microsoft.com/shop <a href='Windows 7: Simplify what you do everyday.' target='_new'>Find the right PC for you.</a></body>
</html>