Well, it sitll does not solve my problem. As I said I am using geometry(planar) with SRID 3044, where units are degrees, therefore when using st_dwithin will still take input in degrees.<br><br><div class="gmail_quote">2011/3/7 Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">Use ST_DWithin instead. <a href="http://www.postgis.org/documentation/manual-1.5SVN/ST_DWithin.html" target="_blank">http://www.postgis.org/documentation/manual-1.5SVN/ST_DWithin.html</a></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">We cover this topic in detail in the first chapter of our book
which is a free download.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"><a href="http://www.postgis.us/chapter_01" target="_blank">http://www.postgis.us/chapter_01</a></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">Leo and Regina</font></span></div><br>
<div dir="ltr" lang="en-us" align="left">
<hr>
<font size="2" face="Tahoma"><b>From:</b>
<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>
[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>] <b>On Behalf Of
</b>michal nagy<br><b>Sent:</b> Monday, March 07, 2011 2:29 AM<br><b>To:</b>
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br><b>Subject:</b> [postgis-users] meters
to degrees<br></font><br></div><div><div></div><div class="h5">
<div></div><font size="3"><span><br></span></font>
<table cellspacing="0" cellpadding="3">
<tbody>
<tr>
<td></td></tr></tbody></table><font size="4"><tt><font color="#1a1a1a">Hello everyone,</font></tt><br><br><tt><font color="#1a1a1a">I am
new to Postgres and PostGIS. I have encountered one problem, that
I</font></tt><br><tt><font color="#1a1a1a">can not deal with.I have table with
various points that have SRID=3044,</font></tt><br><tt><font color="#1a1a1a">which
should be UTM zone including Jutland. I have created function
to</font></tt><br><tt><font color="#1a1a1a">loop through all points in table and
check if they are within given</font></tt><br><tt><font color="#1a1a1a">radius(using geometry and function st_point_inside_circle). Now to
the</font></tt><br><tt><font color="#1a1a1a">problem, for some reason
st_point_inside_circle takes radius in degrees,</font></tt><br><tt><font color="#1a1a1a">which is very inconvenient for me. I would really need to
change to</font></tt><br><tt><font color="#1a1a1a">metres. If anyone has a
suggestion, pls let me know.</font></tt><br><br><tt><font color="#1a1a1a">Thank
you for help</font></tt><br><br><tt><font color="#1a1a1a">Michal</font></tt></font> </div></div></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br>