Uwe C. Schroeder wrote:
in the where clause use something like (requires the earthdistance contrib to be installed):geo_distance(point([origin longitude],[origin latitude]),point([target longitude column],[target latitude column])))::int <= 50
I don't suppose geo_distance really returns a number in miles, does it?
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
