<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
<BR><BR>
<STYLE>
.ExternalClass .ecxhmmessage P
{padding:0px;}
.ExternalClass body.ecxhmmessage
{font-size:10pt;font-family:Verdana;}
</STYLE>
Thanks for your replay, <BR> <BR>I need to check the intersection using lengith3d since the points are in 3D space. so i need to know exactly if they are really intersect.<BR> <BR>can you please help me to develop the query below to give me the result<BR> <BR> <BR>SELECT a,b from try1 as a, try11 as b WHERE ST_Length3d(ST_MakeLine(a.the_geom, b.the_geom)) = 0;<BR><BR> <BR>Kind regards<BR>ihab<BR> <BR>Do a join<BR><BR>SELECT DISTINCT ON(try1.gid) try1.gid, try1.the_geom<BR>FROM try1 INNER JOIN try11 ON ST_Intersects(try1.the_geom, try11.the_geom)<BR>ORDER BY try1.gid<BR><BR>Will give you all the points in try1 that are in try11.<BR><BR><BR><BR><BR> _____ <BR><BR>From: <A href="http://postgis.refractions.net/mailman/listinfo/postgis-users">postgis-users-bounces at postgis.refractions.net</A><BR>[mailto:<A href="http://postgis.refractions.net/mailman/listinfo/postgis-users">postgis-users-bounces at postgis.refractions.net</A>] On Behalf Of eehab<BR>hamzeh<BR>Sent: Sunday, October 11, 2009 3:44 PM<BR>To: <A href="http://postgis.refractions.net/mailman/listinfo/postgis-users">postgis-users at postgis.refractions.net</A><BR>Subject: [postgis-users] check distance between points in table<BR><BR><BR>Hello<BR><BR>I have two tables one its name try1 and the second are try11 i need to check<BR>if any point in try1 and any point in try11 are the same.<BR>i wrote the following fucntion .... But i cant recive resutls<BR><BR>any directions <BR><BR>-- Function: dis3d(geometry)<BR>-- DROP FUNCTION dis3d(geometry);<BR>CREATE OR REPLACE FUNCTION dis3d(point geometry)<BR> RETURNS boolean AS<BR>$BODY$<BR>DECLARE<BR>r try1%rowtype;<BR>BEGIN<BR>for r in select r.the_geom from try1 loop<BR> -- TODO: use && and index <BR>perform the_geom FROM try1 WHERE <BR>ST_Length3d(ST_MakeLine(the_geom, point)) = 0;<BR> <BR> IF FOUND THEN<BR> insert into result(the_geom) select r.the_geom;<BR> ELSE<BR> EXIT;<BR> END IF;<BR>END LOOP;<BR>RETURN true;<BR>END;<BR>$BODY$<BR> LANGUAGE 'plpgsql' VOLATILE STRICT<BR> COST 100;<BR>ALTER FUNCTION dis3d(geometry) OWNER TO postgres;<BR><---------<BR>select dis3d(the_geom) from try11 <BR><BR><BR><BR>
<HR>
Keep your friends updated— <A href="http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social-network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_5:092010">even when you’re not signed in.</A> <br /><hr />Keep your friends updated— <a href='http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social-network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_5:092010' target='_new'>even when you’re not signed in.</a></body>
</html>