All Products
Search

This Product

    PolarDB:ST_isSorted

    Document Center

    PolarDB:ST_isSorted

    Last Updated:Mar 28, 2026

    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);

    Parameters

    ParameterDescription
    pcThe pcpatch object.
    dimnamesThe array of attribute dimension names to check for sorting.
    strictIndicates whether each pcpoint object has unique values for the specified attribute dimensions. Default value: true.

    Examples

    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.