On 07/21/2010 06:01 AM, Geoffrey wrote:
> We need to locate all cities within a certain distance of a single city.
> We have longitude and latitude data for all cities. I was thinking
> postGIS was a viable solution, but I don't see a way to use our existing
> data via postGIS.
>
> Is postGIS a viable solution, or should I be looking at a different
> approach? Thanks for any suggestions or RTFM pointers.
If you want something simple, and not requiring PostGIS, but plpgsql
instead, see:
http://archives.postgresql.org/pgsql-sql/2003-12/msg00193.php
HTH,
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support