All Products
Search
Document Center

ApsaraDB RDS:ST_union

Last Updated:Sep 22, 2023

This topic describes the ST_union function. This function merges a pcpatch array into a pcpatch object.

Syntax

pcpatch ST_union(pcpatch[] pcs);

Parameters

Parameter

Description

pcs

The pcpatch array.

Examples

The following statement provides an example on how to calculate the total number of points in a pcpatch object after the pcpatch array is merged.

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