Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 22 down vote favorite
2

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.

share|improve this question
2  
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 Jul 11 '11 at 9:57
 
Yes, you are right. A point type is returned. Thanks. If you write that as the answer I will accept it. –  Zubair Jul 18 '11 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 Nov 23 '11 at 12:41
1  
You think this might get more traction at Geographic Information Systems? –  Will Dec 6 '11 at 14:24
add comment

1 Answer

up vote 1 down vote

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.