[postgis-users] Distance constraints on spatial points

[Sairam Krishnamurthy]

All,

I have a table with lat,lon values as double and spatial point as Point with
SRID 4326. I have to place a constraint on the spatial point. No two points
can be within a distance of 125m.

So basically if I had a point that is within 125m of a point previously in
the table I should have an error thrown.

Any idea about how to place this distance constraint on the spatial point
field?

TIA

Thanks,
Sairam Krishnamurthy
+1 612 859 8161
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110503/ebb70df1/attachment.html>