PolarDB:ST_Triangulate

Syntax

meshgeom ST_Triangulate(meshgeom geom);

Parameters

Description

This function returns a triangulated geometry object that is used to render models.

Examples

Example 1

SELECT ST_asText(ST_Triangulate('MESHGEOM(PATCH(POLYGON((0 0 0, 1 0 0, 1 1 0, 0 1 0, 0 0 0))))'));
-------------------------------------------------------------------------------
MESHGEOM(PATCH(INDEXSURFACE Z (VERTEX(0 0 0,1 0 0,1 1 0,0 1 0),INDEX((2,3,0),(0,1,2)))))

Example 2

SELECT ST_asText(ST_Triangulate('MESHGEOM(PATCH(INDEXSURFACE( VERTEX(0 0 0,1 0 0,1 1 0,0 1 0),INDEX((0,1,2,3)) )))'));
-------------------------------------------------------------------------------
MESHGEOM(PATCH(INDEXSURFACE Z (VERTEX(0 0 0,1 0 0,1 1 0,0 1 0),INDEX((2,3,0),(0,1,2)))))