SELECT*,
st_distance(ST_GeomFromText('POINT(119.383341323 36.8461558610001)',4326)::GEOGRAPHY, t.geo_location::GEOGRAPHY,TRUE) closestdistance,
st_asgeojson(t.geo_location) geo
FROM device_geo t
WHERE ST_DWithin(ST_GeomFromText('POINT(119.383341323 36.8461558610001)',4326)::GEOGRAPHY, t.geo_location::GEOGRAPHY,100);
postgis 范围搜索创建扩展CREATE EXTENSION IF NOT EXISTS postgis SCHEMA public;设置给系统的schemaALTER EXTENSION postgis SET SCHEMA pg_catalog;geo 表CREATE TABLE device_geo( id BIGSERIAL,...