Re: Search by longitude/latitude

Here is some perl code which does what you want.

----- Original Message -----
From: "Chris Ruprecht" <chrup999(at)yahoo(dot)com>
To: "pgsql" <pgsql-sql(at)postgresql(dot)org>
Sent: Monday, October 08, 2001 8:58 AM
Subject: [SQL] Search by longitude/latitude

> Hi all,
>
> I need to implement "Find all hospitals in a 5 mile radius". Say I have
all
> the coordinates on them stored in a table with the fields longitude and
> latitude. Has anybody some sample code for that?
>
> Best regards,
> Chris
>
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>