[postgis-users] Nearest Neighbour queries in Postgis

[Dylan Beaudette]

On Saturday 02 December 2006 09:27, Sandeep Kumar Jakkaraju wrote:
> Are there any functions for Nearest Neighbour queries in Postgis ???
>
> like the near command of ARCINFO !!
>
> Thanks

how about a self join + distance() + order by distance_to_feature + limit 1 ?

cheers,
-- 
Dylan Beaudette
Soils and Biogeochemistry Graduate Group
University of California at Davis
530.754.7341