Hi All,<br>when i am using this query it gives an error like operator does not exist. My query and error are below--<br>SELECT gid, source, target, the_geom,<br> ST_Distance(the_geom, GeometryFromText(<br> 'POINT(77.549123 28.269926)')) AS dist<br>
FROM routable <br> WHERE the_geom && ST_Expand(CAST(<br> 'BOX(77.549123 28.269926,77.549123 28.269926)' <br> As box2d),200)<br><br><br>ERROR :-<br>ERROR: operator does not exist: geography && box2d<br>
LINE 5: WHERE the_geom && ST_Expand(CAST(<br> ^<br>HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.<br><br>********** Error **********<br>
<br>ERROR: operator does not exist: geography && box2d<br>SQL state: 42883<br>Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.<br>Character: 194<br clear="all">
<br>-- <br>Rakesh Modi<br><br>