With recent postgres//postgis version, you can now use the operator <-> to find nearest rows to a point :
Correct me if I'm wrong, but according to my tests :
SELECT name, gid FROM geonames ORDER BY geom <-> st_setsrid(st_makepoint(-90,40),4326) LIMIT 10;
is the same precision and a bit slower as if I use the Postgres Point type. Now I would like to use this new operator with Geography type to do better calculus on a spheroid.
Is it possible ?