Sorts all pcpoint objects in a pcpatch object based on the specified attribute dimensions and returns a new pcpatch object containing the sorted points.
Syntax
pcpatch ST_sort(pcpatch pc, text[] dimnames);Parameters
| Parameter | Type | Description |
|---|---|---|
pc | pcpatch | The pcpatch object to sort. |
dimnames | text[] | An array of attribute dimension names. |
Examples
The following example sorts the pa column in the patches table by y first, then by x.
UPDATE patches SET pa = ST_sort(pa, ARRAY['y', 'x']);该文章对您有帮助吗？