[postgis-users] Does ST_AsText truncate or round

Paul Ramsey pramsey at cleverelephant.ca
Fri May 16 07:58:00 PDT 2008

Kevin might have some thoughts, he's wrestled with this.

You could put a post-update, post-insert trigger that runs a fine snap
to grid. This will ensure that all vertices remain cojoint. What it
won't do is help with places of co-linearity where there are not


On Fri, May 16, 2008 at 3:23 AM, Paragon Corporation <lr at pcorp.us> wrote:
> Slight clarification about what I am trying to solve.
> After edits I am coming back with lines that used to be intersecting no
> longer intersecting and that still have the same AsText representation.

More information about the postgis-users mailing list