| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Larry Rosenman <ler(at)lerctr(dot)org> |
| Cc: | Tim Perdue <tim(at)perdue(dot)net>, pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: [SQL] Latitude / Longitude |
| Date: | 2002-09-12 19:46:51 |
| Message-ID: | 20020912194651.GA9901@wolff.to |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
On Thu, Sep 12, 2002 at 12:49:21 -0500,
Larry Rosenman <ler(at)lerctr(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tim Perdue | 2002-09-12 19:49:57 | Re: [SQL] Latitude / Longitude |
| Previous Message | Justin Clift | 2002-09-12 19:35:49 | Looking for more "big name" places that use PostgreSQL |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tim Perdue | 2002-09-12 19:49:57 | Re: [SQL] Latitude / Longitude |
| Previous Message | Andrew Perrin | 2002-09-12 19:41:51 | Re: LIMIT within UNION? |