Re: Search by distance - Mailing list pgsql-general

From Jeffrey Melloy
Subject Re: Search by distance
Date
Msg-id 443AD0AE.7080603@visualdistortion.org
Whole thread Raw
In response to Search by distance  (Oscar Picasso <oscgoogle@yahoo.com>)
Responses Re: Search by distance  ("John D. Burger" <john@mitre.org>)
List pgsql-general
Oscar Picasso wrote:

> HI,
>
> I would like to implement a search by distance to my application.
>
> Something like (pseudo sql):
>
> select * from users
> where users.location is less than 15 miles from chicago.
>
> Any documentation on how to implements that?
>
> I guess I also need a database of the cities coordinates. Where could
> I find one?
>
> Thanks
>
> Oscar
>
> ------------------------------------------------------------------------

I can't help you with the coordinates, but this is exactly what the
contrib package PostGIS is designed for.

Jeff

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: PostgreSQL's XML support comparison against other RDBMSes
Next
From: Tyler MacDonald
Date:
Subject: Re: Debian package for freeradius_postgresql module