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

Reply via email to