On Sun, Jun 26, 2005 at 16:40:03 -0700, CSN <[EMAIL PROTECTED]> wrote: > If I have a table of items with latitude and longitude > coordinates, is it possible to find all other items > that are within, say, 50 miles of an item, using the > geometric functions > (http://www.postgresql.org/docs/8.0/interactive/functions-geometry.html)? > If so, how?
You could take a look at using the parts of the earthdistance contrib module based on the cube data type. Gist indexes are supposed to make this kind of query fast. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
