This similar, but not quite the same as this question.
I need to pick, regardless of distance, the closest 'n' points to a given point in another table, using postGIS.
Imagine a table with city names, state names, and a centroid for the city itself, and another table with point information on...