| From: | Tim Perdue <tim(at)perdue(dot)net> |
|---|---|
| To: | Larry Rosenman <ler(at)lerctr(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: [SQL] Latitude / Longitude |
| Date: | 2002-09-12 19:49:57 |
| Message-ID: | 20020912144957.F27651@mail.perdue.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
On Thu, Sep 12, 2002 at 12:49:21PM -0500, Larry Rosenman wrote:
> Look at contrib/earthdistance, I **think** it does what you need.
Thanks, yeah this starts to get me into the realm of what I need. It still
has to run every possible permutation to figure out which one is closest for
each postalcode. What I'll do is run that once and build a 3rd table which can
be used to join the other two together using a view.
Thanks,
Tim
--
Founder - PHPBuilder.com / Geocrawler.com / SourceForge
GPG Public Key: http://www.perdue.net/personal/pgp.php
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Douglas Blood | 2002-09-12 20:50:13 | postgres functions |
| Previous Message | Bruno Wolff III | 2002-09-12 19:46:51 | Re: [SQL] Latitude / Longitude |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2002-09-12 19:52:26 | Re: LIMIT within UNION? |
| Previous Message | Bruno Wolff III | 2002-09-12 19:46:51 | Re: [SQL] Latitude / Longitude |