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
_______________________________________________
dev mailing list
dev@openstreetmap.org
http://lists.openstreetmap.org/listinfo/dev
