PostGIS地理位置不支持"~=“函数/运算符

SELECT PostGIS_full_version();

ALTER EXTENSION postgis UPDATE;

GRANT USAGE ON SCHEMA public TO your_user;
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO your_user;
GRANT USAGE ON ALL SEQUENCES IN SCHEMA public TO your_user;

-- 创建一个包含地理空间数据的表
CREATE TABLE locations (
    id SERIAL PRIMARY KEY,
    geom GEOMETRY(Point, 4326)
);

-- 插入一些数据
INSERT INTO locations (geom) VALUES 
    (ST_SetSRID(ST_MakePoint(-122.4194, 37.7749), 4326)),
    (ST_SetSRID(ST_MakePoint(-122.4195, 37.7750), 4326));

-- 使用 ~= 运算符进行相似性判断
SELECT id 
FROM locations 
WHERE geom ~= ST_SetSRID(ST_MakePoint(-122.4194, 37.7749), 4326);