Re: [GENERAL] Latitude / Longitude - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: [GENERAL] Latitude / Longitude
Date
Msg-id 20020912194651.GA9901@wolff.to
Whole thread Raw
In response to Re: Latitude / Longitude  (Larry Rosenman <ler@lerctr.org>)
List pgsql-sql
On Thu, Sep 12, 2002 at 12:49:21 -0500,
  Larry Rosenman <ler@lerctr.org> wrote:
> Look at contrib/earthdistance, I **think** it does what you need.

There isn't an index for the distance operator. You can use boxes to
limit the candidates if there is a small bound on how far apart points
can be before they are no longer candidates for a match even if they
are a nearest neighbor pair.

pgsql-sql by date:

Previous
From: Roland Roberts
Date:
Subject: Re: LIMIT within UNION?
Next
From: Andrew Perrin
Date:
Subject: Re: LIMIT within UNION?