No subject

facilities

for
SELECT p.poi_name, round(CAST(ST_Distance(p.poi_geom, c.line_geom) / 1000 As
numeric),2) As dist_km FROM hello.poi As p INNER JOIN hello.coastline As c
ON ST_DWithin(c.line_geom, p.poi_geom, 1000*3);

I get result "Hospital";0.92
checked it in openjump also and found correct.

The text of the pdf document indicates
poiname dist_km
Hospital 2.8

If this is my mistake I would like to correct myself.

Ravi


      Love Cricket? Check out live scores, photos, video highlights and
more. Click here http://cricket.yahoo.com
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users