Re: [GENERAL] calculating distance between longitude and latitude

2010-06-10 Thread Merlin Moncure
On Wed, Jun 9, 2010 at 3:02 PM, Geoffrey 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 super accurate results (ok w

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

Re: [GENERAL] calculating distance between longitude and latitude

2010-06-09 Thread Szymon Guz
2010/6/9 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

[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 Jef