[postgis-users] check distance between points in table
eehab40 at hotmail.com
Sun Oct 11 12:44:07 PDT 2009
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.
i wrote the following fucntion .... But i cant recive resutls
-- Function: dis3d(geometry)
-- DROP FUNCTION dis3d(geometry);
CREATE OR REPLACE FUNCTION dis3d(point geometry)
RETURNS boolean AS
for r in select r.the_geom from try1 loop
-- TODO: use && and index
perform the_geom FROM try1 WHERE
ST_Length3d(ST_MakeLine(the_geom, point)) = 0;
IF FOUND THEN
insert into result(the_geom) select r.the_geom;
LANGUAGE 'plpgsql' VOLATILE STRICT
ALTER FUNCTION dis3d(geometry) OWNER TO postgres;
select dis3d(the_geom) from try11
Windows Live: Make it easier for your friends to see what you’re up to on Facebook.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users