All Products
Search
Document Center

PolarDB:ST_Triangulate

Last Updated:Mar 28, 2026

Triangulates a meshgeom geometry object and returns the result for model rendering.

Syntax

meshgeom ST_Triangulate(meshgeom geom);

Parameters

ParameterDescription
geomThe meshgeom object to triangulate.

Description

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

Examples

Triangulate a POLYGON patch

The input is a single quadrilateral polygon. ST_Triangulate decomposes it into two triangles.

SELECT ST_asText(ST_Triangulate('MESHGEOM(PATCH(POLYGON((0 0 0, 1 0 0, 1 1 0, 0 1 0, 0 0 0))))'));

Output:

MESHGEOM(PATCH(INDEXSURFACE Z (VERTEX(0 0 0,1 0 0,1 1 0,0 1 0),INDEX((2,3,0),(0,1,2)))))

Triangulate an INDEXSURFACE patch

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)) )))'));

Output:

MESHGEOM(PATCH(INDEXSURFACE Z (VERTEX(0 0 0,1 0 0,1 1 0,0 1 0),INDEX((2,3,0),(0,1,2)))))