Re: [GENERAL] calculating distance between longitude and latitude

2010-06-10 Thread Merlin Moncure
On Wed, Jun 9, 2010 at 3:02 PM, Geoffrey li...@serioustechnology.com wrote: Does postgresql have functions to calculate the distance between two sets of longitude and latitude. for posterity, if you are not: *) very interested in high performance (that is, ok w/sql implementation) *) needing

[GENERAL] calculating distance between longitude and latitude

2010-06-09 Thread Geoffrey
Does postgresql have functions to calculate the distance between two sets of longitude and latitude. -- Until later, Geoffrey I predict future happiness for America if they can prevent the government from wasting the labors of the people under the pretense of taking care of them. - Thomas

Re: [GENERAL] calculating distance between longitude and latitude

2010-06-09 Thread Szymon Guz
2010/6/9 Geoffrey li...@serioustechnology.com Does postgresql have functions to calculate the distance between two sets of longitude and latitude. -- Until later, Geoffrey I predict future happiness for America if they can prevent the government from wasting the labors of the people under

Re: [GENERAL] calculating distance between longitude and latitude

2010-06-09 Thread Uwe Schroeder
Does postgresql have functions to calculate the distance between two sets of longitude and latitude. You're looking for the earthdistance contrib module. With most Linux distros it's installed under /usr/share/postgresql/8.xx/contrib You may have to install a postgresql-contrib package