Postgres Pro
Downloads
Home   >   mailing lists

Finding points within 50 miles - Mailing list pgsql-general

From CSN
Subject Finding points within 50 miles
Date
Msg-id 20050626234003.59478.qmail@web52903.mail.yahoo.com
Whole thread Raw
Responses Re: Finding points within 50 miles  (Janning Vygen <vygen@gmx.de>)
Re: Finding points within 50 miles  ("Uwe C. Schroeder" <uwe@oss4u.com>)
Re: Finding points within 50 miles  (Vivek Khera <vivek@khera.org>)
Re: Finding points within 50 miles  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Zlatko Matic"
Date:
Subject: Re: automating backup ?
Next
From: "Harvey, Allan AC"
Date:
Subject: Re: automating backup ?