Hi rakesh, '26.8988086602918-200' will be used as text without computing a number.
Gr Ralf Am Donnerstag 29 April 2010 14:19:53 schrieb 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; _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
