[postgis-users] nearest point data

[David William Bitner]

select * from villages order by distance((select geom from towns where
town='mytown'),geom) asc limit 1;

On 7/25/06, temiz <temiz at deprem.gov.tr> wrote:
>
> hello
>
> I wonder how I can find nearest point data to another point data. All
> reside in different tables.
> such as nearest towns to villages concerned.
>
>
> regards
>
>
> Ahmet Temiz
>
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
************************************
David William Bitner
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060725/1f664101/attachment.html>