How can I query the postgres Point type from clojureql?

Question

How can I query the postgres Point type from clojureql? I wish to use the PostGIS functionality but clojureql does not seem to include this.

Do you know what type gets returned if you query the table? Maybe try (class returned-object) to find out, then you can look at the associated JavaDoc — mikera
– mikera, Commented Jul 11, 2011 at 9:57
Yes, you are right. A point type is returned. Thanks. If you write that as the answer I will accept it. — yazz.com
– yazz.com, Commented Jul 18, 2011 at 17:18
The data type point is implemented in standard PostgreSQL, PostGis is not involved so far. This question turned out not to be a question at all, just several misunderstandings at once. — Erwin Brandstetter
– Erwin Brandstetter, Commented Nov 23, 2011 at 12:41
You think this might get more traction at Geographic Information Systems? — user1228
– user1228, Commented Dec 6, 2011 at 14:24

simonecampora · Accepted Answer · 2012-01-02 17:22:22Z

2

I am not an expert in clojureql, but if this syntax is correct:

(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))))

(taken from here)

why not trying to change the rs into:

select point[0] as x, point[1] as y from table

Will this work? I am not sure it will, but if this Clojure way of querying is simply forwarding the query to the DB "asis" you might try using as well PostGIS operators in it.

answered Jan 2, 2012 at 17:22

simonecampora

3972 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I query the postgres Point type from clojureql?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related