[postgis-users] how to set precision

[Kevin Neufeld]

On 2/10/2010 12:36 AM, Marko Čubranić wrote:
> hi
>
> i want to set geometry precision in postgis database, can i do that?


Yes, use ST_SnapToGrid[1].  Wrap it with a ON INSERT/UPDATE rule or trigger on every spatial table in your database and 
you'll in effect ensure your entire database is set to some grid.  Although it's not the same as geometry precision, 
it's the closest proxy we have to it at the moment.


[1] http://postgis.refractions.net/docs/ST_SnapToGrid.html

-- Kevin