<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
Hello<BR>
<BR>
I have two tables one its name try1 and the second are try11 i need to check 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> <br /><hr />Windows Live: Make it easier for your friends to see <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_2:092009' target='_new'>what you’re up to on Facebook.</a></body>
</html>