Use ST_DWithin instead. http://www.postgis.org/documentation/manual-1.5SVN/ST_DWithin.html We cover this topic in detail in the first chapter of our book which is a free download. http://www.postgis.us/chapter_01 Leo and Regina
_____ From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of michal nagy Sent: Monday, March 07, 2011 2:29 AM To: postgis-users@postgis.refractions.net Subject: [postgis-users] meters to degrees Hello everyone, I am new to Postgres and PostGIS. I have encountered one problem, that I can not deal with.I have table with various points that have SRID=3044, which should be UTM zone including Jutland. I have created function to loop through all points in table and check if they are within given radius(using geometry and function st_point_inside_circle). Now to the problem, for some reason st_point_inside_circle takes radius in degrees, which is very inconvenient for me. I would really need to change to metres. If anyone has a suggestion, pls let me know. Thank you for help Michal
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
