[postgis-users] Error in analysis

[Ravi]

Hi,
From PostGIS_MEAPCH01.pdf have done the exercise
Coastline and public 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