Oscar Picasso wrote:
HI,
I would like to implement a search by distance to my application.
Something like (pseudo sql):
select * from users
where users.location is less than 15 miles from chicago.
Any documentation on how to implements that?
I guess I also need a database of the cities coordinates. Where could
I find one?
Thanks
Oscar
------------------------------------------------------------------------
I can't help you with the coordinates, but this is exactly what the
contrib package PostGIS is designed for.
Jeff
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly