SELECT * FROM test where ST_Dwithin(ST_geomfromtext(
'POINT(100 28)')::GEOGRAPHY,location,1000)IS TRUE;
location是geography类型,为其添加的gist索引,但是查询不走索引
SELECT * FROM test where ST_Dwithin(ST_geomfromtext(
'POINT(100 28)')::GEOGRAPHY,location,1000)IS TRUE;
location是geography类型,为其添加的gist索引,但是查询不走索引