ST_3DUnion — Perform 3D union.


geometry ST_3DUnion(geometry geom1, geometry geom2);

geometry ST_3DUnion(geometry set g1field);



ST_3DUnion is deprecated as of 3.5.0. Use CG_3DUnion instead.

Disponibilità: 2.2.0

Availability: 3.3.0 aggregate variant was added

Questo metodo richiede il backend SFCGAL.

Questo metodo implementa la specifica SQL/MM. SQL-MM IEC 13249-3: 5.1

Questa funzione supporta il 3d e non distrugge gli z-index.

Questa funzione supporta le Polyhedral Surface.

Questa funzione supporta i Triangoli e le Triangulated Irregular Network Surfaces (TIN).

Aggregate variant: returns a geometry that is the 3D union of a rowset of geometries. The ST_3DUnion() function is an "aggregate" function in the terminology of PostgreSQL. That means that it operates on rows of data, in the same way the SUM() and AVG() functions do and like most aggregates, it also ignores NULL geometries.