[postgis-users] Fixing badly noded Multilinestrings

[Peter]

If i use st_snaptogrid to fix badly noded lines (ie some lines that are meant to end exactly where another starts, dont) surely this will fail in rare cases, either side of the cut off point, eg:

select
    st_astext(
      st_snaptogrid(  st_geomfromtext('MULTILINESTRING((0 0,100.49 200),(100.51 200, 300 300))'),1    )
   )
   
-- gives MULTILINESTRING((0 0,100 200),(101 200,300 300))

Is there a way around this?

Peter