Re: Finding points within 50 miles

From: Alban Hertroys <alban(at)magproductions(dot)nl>
To: "Uwe C(dot) Schroeder" <uwe(at)oss4u(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Finding points within 50 miles
Date: 2005-06-27 09:08:35
Message-ID: 42BFC213.4020502@magproductions.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Uwe C. Schroeder wrote:

>in the where clause use something like (requires the earthdistance contrib to
>be installed):
>
>geo_distance(point([origin longitude],[origin latitude]),point([target
>longitude column],[target latitude column])))::int <= 50
>
>
I don't suppose geo_distance really returns a number in miles, does it?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marco Colombo 2005-06-27 09:44:11 Re: automating backup ?
Previous Message Oleg Bartunov 2005-06-27 08:46:17 Re: Finding points within 50 miles