ST_isSorted-PolarDB(PolarDB)-阿里云帮助中心

Returns true if all pcpoint objects in a pcpatch are sorted by the specified attribute dimensions.

Syntax

boolean ST_isSorted(pcpatch pc, text[] dimnames, boolean strict default true);

Parameter	Description
`pc`	The `pcpatch` object.
`dimnames`	The array of attribute dimension names to check for sorting.
`strict`	Indicates whether each `pcpoint` object has unique values for the specified attribute dimensions. Default value: `true`.

SELECT ST_isSorted(pa, Array['a','c']) FROM patches;

Output:

 f
(1 rows)

The result f indicates that the pcpoint objects in the pa column are not sorted by dimensions a and c.