[postgis-users] SetSRID functin does not exist

[Ralf Suhr]

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;