我不是clojureql的专家,但如果这个语法是正确的:
(with-connection db (with-query-results rs ["select * from blogs"] ; rs will be a sequence of maps,; one for each record in the result set. (dorun (map #(println (:title %)) rs))))
(取自here)
为什么不尝试将rs更改为:
select point[0] as x,point[1] as y from table
这将工作吗?我不确定它会,但如果这种Clojure的查询方式只是将查询转发到DB“asis”,您可以尝试使用PostGIS操作符。