<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
<div>
<div>
<div>
<div>Hello, i'm having a problem that i find strange with intersecting geometries. I have two geometries, they intersect in 3d but not in 2d. How is this possible?</div>
</div>
</div>
</div>
<div>
<div></div>
</div>
<div>
<div>
<div>
<div>Here's a sample:</div>
<div><br>
</div>
<div><span>with x as (<br>
</span>
<div>select <br>
</div>
<div>st_geomfromewkb('\x01020000a0b30e000002000000947bdfddb6b3e6c0563ada3e089204410000000000000000957bdfdd36b1e6c060dcd03e089204410000000000000000') as broken_geom,<br>
</div>
<div>st_geomfromewkb('\x0102000020b30e00000e000000b34ffa12d0b2e6c099d9d63e0892044135ff664cd8b2e6c0045b0799079204419a71eb3de1b2e6c01a83fdfe069204415b5ca842eab2e6c0930530690692044140271ba8f3b2e6c02d065ee405920441de0afec7fcb2e6c0fca16e8e0592044185ae750a06b3e6c073a9671c0592044169af95520fb3e6c0134c1ed40492044173cde2c218b3e6c0a892c48604920441f8f7d21f22b3e6c0db66bf6b04920441d13e0c902bb3e6c0f1384f4004920441e8ae92dc34b3e6c0388f5e3d0492044120cb297f3eb3e6c02ff6c54204920441cd9519fe47b3e6c0437fde4904920441')
as blade<br>
</div>
<div> )<br>
</div>
<div> select st_3dintersects(broken_geom, blade), st_intersects(broken_geom, blade) from x;<br>
</div>
<div>NOTICE: One or both of the geometries is missing z-value. The unknown z-value will be regarded as "any value"<br>
</div>
<div> st_3dintersects | st_intersects <br>
</div>
<div>-----------------+---------------<br>
</div>
<div> t | f<br>
</div>
<span>(1 row)</span><br>
</div>
</div>
</div>
</div>
<div>
<div></div>
</div>
<div>
<div>
<div>
<div><br>
</div>
</div>
</div>
</div>
<div>
<div></div>
</div>
<div>
<div>any ideas?</div>
</div>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
Best regards,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
Alexandre Silva<br>
</div>
<div id="Signature">
<div id="divtagdefaultwrapper" dir="ltr" style="font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: Calibri, Arial, Helvetica, sans-serif;">
<p style="margin-top: 0px; margin-bottom: 0px;"><span id="ms-rterangepaste-start"></span></p>
<table style="color: rgb(33, 33, 33); font-size: 15px; width: 430px;" width="430">
<tbody>
<tr>
<td><br>
</td>
<td><br>
</td>
<td><br>
</td>
<td><br>
</td>
</tr>
</tbody>
</table>
<br>
<p style="margin-top: 0px; margin-bottom: 0px;"></p>
</div>
</div>
<img src="http://newsletter.impresapublishing.pt/i/barra_ip.jpg">
</body>
</html>