earthdistance results seem to be wrong. - Mailing list pgsql-general

From mikecoxlinux@yahoo.com (Mike Cox)
Subject earthdistance results seem to be wrong.
Date
Msg-id 3d6111f1.0410011315.1d4cf6bc@posting.google.com
Whole thread Raw
Responses Re: earthdistance results seem to be wrong.  (Chris Mair <list@1006.org>)
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.

pgsql-general by date:

Previous
From: Edmund Bacon
Date:
Subject: Re: earthdistance is not giving correct results.
Next
From: Mike Rylander
Date:
Subject: Re: Query problem...