Re: earthdistance is not giving correct results.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mike cox <mikecoxlinux(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: earthdistance is not giving correct results.
Date: 2004-10-02 23:09:25
Message-ID: 25836.1096758565@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

mike cox <mikecoxlinux(at)yahoo(dot)com> writes:
> The distance from Portland to Seattle is not 128862
> miles.

How about 128.8 kilometers? The earthdistance docs say it's in meters
unless you've redefined the base unit.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-10-02 23:15:25 Re: VACUUM FULL on 24/7 server
Previous Message Tom Lane 2004-10-02 22:46:58 Re: Bug with updateable Views and inherited tables?