PostGIS
Name
TopoGeom_addTopoGeom — Adds element of a TopoGeometry to the definition of another TopoGeometry.
Description
Adds the elements of a TopoGeometry to the definition of another TopoGeometry, possibly changing its cached type (type attribute) to a collection, if needed to hold all elements in the source object.
The two TopoGeometry objects need be defined against the same topology and, if hierarchically defined, need be composed by elements of the same child layer.
Availability: 3.2
Examples
-- Set an "overall" TopoGeometry value to be composed by all
-- elements of specific TopoGeometry values
UPDATE mylayer SET tg_overall = TopoGeom_addTopogeom(
TopoGeom_addTopoGeom(
clearTopoGeom(tg_overall),
tg_specific1
),
tg_specific2
);