Scans all pcpoint objects in a pcpatch object, finds the minimum value across every attribute dimension, and returns a new pcpoint whose dimensions are set to those minimums.
Syntax
numeric ST_patchMin(pcpatch pc);Parameters
| Parameter | Type | Description |
|---|---|---|
pc | pcpatch | The pcpatch object to scan. |
Examples
The following example retrieves the pcpatch with id = 7 from the patches table and returns a pcpoint whose dimensions are all set to their minimum values.
SELECT ST_AsText(ST_PatchMin(pa)) FROM patches WHERE id = 7;Output:
{"pcid":1,"pt":[-126.5,45.5,50,5]}The returned pt array lists the minimum value for each dimension in the point cloud schema defined by pcid.
该文章对您有帮助吗？