Sorry, I didn't explain myself very well, now I can: I don't need in every vertex a point or a node. I want to rebuild my geometry by adding new nodes where I need.
This is the logic that I want in pgsql code: 1. Read over all the multilinestrings that I have, all the_geom in this case,(Is really neccesary to explode them into linestrings?) 2. By default the first point will be the start node, and i will store it in position[1], when I stop in a vertex, ask to postgis If there's an intersection, if there`s one, store it in position[2], if there's an actual node (will be the end node), store it, and close the multilinestring. 3. Repeat that process on the next node. Thank you Nicolas. -- View this message in context: http://old.nabble.com/Split-Multistring-on-the_geom-tp28597888p28610253.html Sent from the PostGIS - User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users