I have a database with the earthdistance contrib module installed and I need to find records whose long & latitude are within a given distance of a zip code. From the documentation on earthdistance, I believe it is certainly possible to do a "find points within a distance of another point" using the ll_to_earth, earth_box, and earth_distance functions. What would be the advantages to installing and using PostGIS instead? I would like to avoid adding another dependency to the system and I think earthdistance will be able to do what I need. However, I'll certainly try PostGIS if it has a significant performance advantage. Can anyone talk a bit about the pros and cons of earthdistance and PostGIS? -- --- John L Cheng -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
