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

2010-07-14 Thread Jon Burgess 
On Thu, 2010-07-15 at 02:27 +0530, PARVEEN ARORA wrote:
> SELECT id, name AsText(geom) FROM roads

Should this be:

SELECT id, name, AsText(geom) FROM roads




___
dev mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/dev

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

2010-07-14 Thread 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

___
dev mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/dev