[PostGIS] #6095: add fixVertexSegmentPairsBelowDistance

[PostGIS]

#6095: add fixVertexSegmentPairsBelowDistance
--------------------------------+-----------------------------
  Reporter:  Lars Aksel Opsahl  |      Owner:  strk
      Type:  enhancement        |     Status:  new
  Priority:  medium             |  Milestone:  PostGIS Fund Me
 Component:  topology           |    Version:
Resolution:                     |   Keywords:
--------------------------------+-----------------------------
Comment (by Lars Aksel Opsahl):

 Just did a test with  DISTINCT ON (vs.vert_geom) using TopoGeo_AddPoint no
 error from TopoGeo_AddPoint but no fix of is valid for test case t2

 {{{


 DO $$
 DECLARE
                 r RECORD;
 BEGIN
                 FOR r IN
                                 SELECT DISTINCT ON (vs.vert_geom)
                                                         e.geom,
                                                         vs.vert_geom
                                 FROM
 topology.FindVertexSegmentPairsBelowDistance(
 'grunnkart_037',
                                                                 1e-7
                                                 ) AS vs
                                 JOIN grunnkart_037.edge e
                                         ON e.edge_id = vs.seg_edge
                                 ORDER BY vs.vert_geom
                 LOOP
                                 BEGIN
                                                 --PERFORM
 topology.TopoGeo_addLinestring( 'grunnkart_037', ST_ShortestLine(r.geom,
 r.vert_geom), -1 );
                                                 PERFORM
 topology.TopoGeo_AddPoint( 'grunnkart_037', r.vert_geom, -1 );

                                 EXCEPTION
                                                 WHEN OTHERS THEN
                                                                 RAISE
 WARNING 'Failed: %, error: %',
 ST_AsText(r.vert_geom),
 SQLERRM;
                                 END;
                 END LOOP;
 END;
 $$;

 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/6095#comment:4>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.