[postgis-users] Distance constraints on spatial points

[Sairam Krishnamurthy]

Thanks. But how do I specify the code to raise an error if the distance is
not met ? I am sure I can find out the number of points within 125m of the
new point. And if the query returns anything other than null, the constraint
is not met.

But I am not sure what to do after that.

Thanks,
Sairam Krishnamurthy
+1 612 859 8161


On Tue, May 3, 2011 at 3:45 PM, fork <forkandwait at gmail.com> wrote:

> Sairam Krishnamurthy <kmsram420 <at> gmail.com> writes:
>
> > Any idea about how to place this distance constraint on
> > the spatial point field?
>
> A trigger in PL/PGSQL?
>
> http://www.postgresql.org/docs/9.0//static/plpgsql-trigger.html
>
> Sorry that I don't have a more developed example at hand.
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110503/254fab02/attachment.html>