i'm searching nearest ten neighbor points from a giving point.
When i use this query:
SELECT id, geom, ST_Distance(geography(geom), ST_GeographyFromText('SRID=4326;POINT(-0.22707 51.5444204)')) as distanceFROM carsORDER BY geom 'SRID=4326;POINT(-0.22707 51.5444204)'::geometryLIMIT 10;
i...