[postgis] distance(geometry,geometry) function

Dave Blasby dblasby at refractions.net
Mon Jul 23 17:17:51 PDT 2001


Due to popular demand, I've added the function;

distance(geometry,geometry)	
	:- finds the minimum distance between the two geometries

now you can do things like;

select * from <table> where distance(<geometry col>,'POLYGON(0 0, 0 10,
10 10, 10 0, 0 0)') < 10.0;

which will find anything that is within 10 units of the given polygon.

This will greatly increase the complexity of spatial queries users will
be able to perform.

I'm still testing it; it should hit the CVS version in the next few
days.

dave

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Secure your servers with 128-bit SSL encryption! Grab your copy of
VeriSign's FREE Guide "Securing Your Web Site for Business." Get it now!
http://www.verisign.com/cgi-bin/go.cgi?a=n094442340008000
http://us.click.yahoo.com/6lIgYB/IWxCAA/yigFAA/PhFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ 





More information about the postgis-users mailing list