Name
ST_NumPatches — Return the number of faces on a Polyhedral Surface. Will return null for non-polyhedral geometries.
Synopsis
integer ST_NumPatches(geometry g1);
Descrizione
Return the number of faces on a Polyhedral Surface. Will return null for non-polyhedral geometries. This is an alias for ST_NumGeometries to support MM naming. Faster to use ST_NumGeometries if you don't care about MM convention.
Disponibilità: 2.0.0
Questa funzione supporta il 3d e non distrugge gli z-index.
Questo metodo implementa le OGC Simple Features Implementation Specification for SQL 1.1.
Questo metodo implementa la specifica SQL/MM. SQL-MM ISO/IEC 13249-3: 8.5
Questa funzione supporta le Polyhedral Surface.
Esempi
SELECT ST_NumPatches(ST_GeomFromEWKT('POLYHEDRALSURFACE( ((0 0 0, 0 0 1, 0 1 1, 0 1 0, 0 0 0)),
((0 0 0, 0 1 0, 1 1 0, 1 0 0, 0 0 0)), ((0 0 0, 1 0 0, 1 0 1, 0 0 1, 0 0 0)),
((1 1 0, 1 1 1, 1 0 1, 1 0 0, 1 1 0)),
((0 1 0, 0 1 1, 1 1 1, 1 1 0, 0 1 0)), ((0 0 1, 1 0 1, 1 1 1, 0 1 1, 0 0 1)) )'));
--result
6