Hi Mark,
Look at Postgis, to do this properly. It adds full OGC spec support for managing spatial/querying spatial data within a Postgres database.
It is an option included with the Windows Postgres installer, but is generally extra packages under Linux.
Cheers,
Brent Wood
>>> mark <markkicks(at)gmail(dot)com> 07/11/08 5:34 AM >>>
hi..
i want to store latitude and longitude in a users table.. what is the
best data type to use for this? i want to be able to find use this
info to find users within a distance..
how do i go about doing this?
thanks