ST_AddIsoNode — Adds an isolated node to a face in a topology and returns the nodeid of the new node. If face is null, the node is still created.
integer ST_AddIsoNode(varchar atopology, integer aface, geometry apoint
Adds an isolated node with point location
apoint to an existing face with faceid
aface to a topology
atopology and returns the nodeid of the new node.
If the spatial reference system (srid) of the point geometry is not the same as the topology, the
apoint is not a point geometry, the point is null, or the point intersects an existing edge (even at the boundaries) then an exception is thrown. If the point already
exists as a node, an exception is thrown.
aface is not null and the
apoint is not within the face, then an exception is thrown.
This method implements the SQL/MM specification. SQL-MM: Topo-Net Routines: X+1.3.1