[postgis-users] SetSRID functin does not exist

[rakesh modi]

Hi All,

i am trying to run this query but getting error -
ERROR:  function setsrid(unknown) does not exist
LINE 4:             FROM roads WHERE the_geom && SetSRID(
                                                 ^
what's the problem ..


SELECT gid, source, target, the_geom,
 distance(the_geom, GeometryFromText(
 'POINT(26.8988086602918 7.71874658182343)', 4326)) AS dist
            FROM roads WHERE the_geom && ST_SetSRID(
                  'BOX3D((26.8988086602918-200 7.71874658182343-200
26.8988086602918+200 7.71874658182343+200))
                         , ::box3d,4326)')
            ORDER BY dist LIMIT 1;
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100429/0427e4e9/attachment.html>