Quick Links

Finding points within 50 miles

From:	CSN <cool_screen_name90001(at)yahoo(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	Finding points within 50 miles
Date:	2005-06-26 23:40:03
Message-ID:	20050626234003.59478.qmail@web52903.mail.yahoo.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

If I have a table of items with latitude and longitude
coordinates, is it possible to find all other items
that are within, say, 50 miles of an item, using the
geometric functions
(http://www.postgresql.org/docs/8.0/interactive/functions-geometry.html)?
If so, how?

Thanks,
CSN

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Responses

Re: Finding points within 50 miles at 2005-06-27 07:47:36 from Janning Vygen
Re: Finding points within 50 miles at 2005-06-27 08:09:11 from Uwe C. Schroeder
Re: Finding points within 50 miles at 2005-06-27 14:41:20 from Vivek Khera
Re: Finding points within 50 miles at 2005-06-27 15:29:49 from Bruno Wolff III

Browse pgsql-general by date

	From	Date	Subject
Next Message	Harvey, Allan AC	2005-06-27 00:51:41	Re: automating backup ?
Previous Message	Zlatko Matic	2005-06-26 23:21:07	Re: automating backup ?