[OSM-dev] AsText & DISTANCE Function error in PostGIS

[PARVEEN ARORA]

Hello Everyone,

I am trying to use function AsText in PostGIS  But it gies error.



SELECT id, name AsText(geom) FROM roads
WHERE DISTANCE(geom, GeomFromText(‘POINT(5 5)’, -1)) < 5;

here roads is table name.
 error is:
ERROR:  syntax error at or near "("
LINE 1: SELECT id, name AsText(geom) FROM roads
                              ^

Please Help

-- 
With Kind Regards
Parveen Arora
osmpunjab.co.cc