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
signature.asc
Description: OpenPGP digital signature
