[postgis-users] nearest points

[jj.wag at gmx.de]

Hi,
I try to get the nearest 100 points from a postgis-point table 
(blom_north_p) to a point that comes in WKT:

select gid, location, 
ST_distance(blom_north_p.the_geom,GeomFromText('POINT(3455552.13983 
5481389.60828)',31467)) as mydist FROM blom_north_p order by mydist asc 
limit 100;

But the returend points are not correct.
What is wrong with my syntax?
Thanks
Jo
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090317/18d5d05a/attachment.html>