earthdistance is not giving correct results. - Mailing list pgsql-general

From mike cox
Subject earthdistance is not giving correct results.
Date
Msg-id 20041001012307.82207.qmail@web52803.mail.yahoo.com
Whole thread Raw
Responses Re: earthdistance is not giving correct results.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I'm running PostgreSQL 8.0 beta 1.  I'm using the
earthdistance to find the distance between two
different latitude and logitude locations.
Unfortunately, the result seems to be wrong.

Here is what I'm doing:
select
earth_distance(ll_to_earth('122.55688','45.513746'),ll_to_earth('122.396357','47.648845'));

The result I get is this:

128862.563227506

The distance from Portland to Seattle is not 128862
miles.






__________________________________
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail

pgsql-general by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: ODBC for PostgreSQL 7.4
Next
From: phil
Date:
Subject: New Student