Postgres:使用 BETWEEN SYMMETRIC 进行过滤

Question

我正在尝试使用BETWEEN SYMMETRIC根据坐标过滤数据点，如以下查询所示：

SELECT user_id
, duration
, distance
, speed
FROM trips_metrics
WHERE lat_start BETWEEN SYMMETRIC (39.45 AND 40.05) AND lat_end  BETWEEN SYMMETRIC (39.45 AND 40.05)
AND lon_start BETWEEN SYMMETRIC (115.41667 AND 117.5) AND lon_end BETWEEN SYMMETRIC (115.41667 AND 117.5)
ERROR:  syntax error at or near "BETWEEN"
LINE 6: ... BETWEEN SYMMETRIC (39.45 AND 40.05) AND lat_end  BETWEEN SY...

仅使用地理区域过滤用户的行程。

Answer 1

不要使用括号。 所以：

lat_start BETWEEN SYMMETRIC 39.45 AND 40.05

当然，您的值已经按顺序排列，因此SYMMETRIC对于您的查询来说是多余的。