Re: Finding points within 50 miles - Mailing list pgsql-general

From Alban Hertroys
Subject Re: Finding points within 50 miles
Date
Msg-id 42BFC213.4020502@magproductions.nl
Whole thread Raw
In response to Re: Finding points within 50 miles  ("Uwe C. Schroeder" <uwe@oss4u.com>)
Responses Re: Finding points within 50 miles  ("Uwe C. Schroeder" <uwe@oss4u.com>)
List 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?


pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Finding points within 50 miles
Next
From: Marco Colombo
Date:
Subject: Re: automating backup ?