[postgis-users] How do I get 'n' points nearest another point?

[Gerry Creager - NOAA Affiliate]

I've two tables, one with a set of city centroids, and one with radar
locations. I need to select the 4 (or maybe 5) closes radars to a given
city point.

I know I've done something similar, but that was 2 or 3 major releases ago,
and the syntax is now foreign to me!

Thanks in advance,
gerry
-- 
Gerry Creager
NSSL/CIMMS
405.325.6371
++++++++++++++++++++++
“Big whorls have little whorls,
That feed on their velocity;
And little whorls have lesser whorls,
And so on to viscosity.”
Lewis Fry Richardson (1881-1953)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150622/1c574e46/attachment.html>