Re: earthdistance results seem to be wrong.

From: Chris Mair <list(at)1006(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: earthdistance results seem to be wrong.
Date: 2004-10-03 15:29:01
Message-ID: 1096817341.15333.9.camel@dell
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> 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.

It is 128000m = 128km.

Welcome to the metric system :)

Bye, Chris.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Luc Lachance 2004-10-03 15:36:20 Re: earthdistance is not giving correct results.
Previous Message Alvaro Herrera 2004-10-03 15:18:33 Re: sequence rename?