<div>Hi All,</div><div><br></div><div>i am trying to run this query but getting error - </div><div><div>ERROR: function setsrid(unknown) does not exist</div><div>LINE 4: FROM roads WHERE the_geom && SetSRID(</div>
<div> ^</div><div>what's the problem .. </div></div><div><br></div><div><br></div><div>SELECT gid, source, target, the_geom, </div><div><span class="Apple-tab-span" style="white-space:pre"> </span> distance(the_geom, GeometryFromText(</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span> 'POINT(26.8988086602918 7.71874658182343)', 4326)) AS dist </div><div> FROM roads WHERE the_geom && ST_SetSRID(</div><div> 'BOX3D((26.8988086602918-200 7.71874658182343-200 26.8988086602918+200 7.71874658182343+200))</div>
<div> , ::box3d,4326)') </div><div> ORDER BY dist LIMIT 1;</div>