ST_union function to merge a pcpatch array into a pcpatch object - ApsaraDB RDS

Merges a pcpatch array into a single pcpatch object.

Syntax

pcpatch ST_Union(pcpatch[] pcs);

Parameter	Description
`pcs`	The pcpatch array to merge.

The following example merges all pcpatch values in the patches table and returns the total number of points.

SELECT ST_NumPoints(ST_Union(pa)) FROM patches;
 st_numpoints
--------------
          100
(1 row)