云数据库 GAUSSDB-CREATE OPERATOR:示例

时间:2024-11-02 18:50:34

示例

下面命令定义一个新操作符:面积相等,用于box数据类型。

gaussdb=# CREATE OPERATOR === (
    LEFTARG = box,
    RIGHTARG = box,
    PROCEDURE = area_equal_procedure,
    COMMUTATOR = ===,
    NEGATOR = !==,
    RESTRICT = area_restriction_procedure,
    JOIN = area_join_procedure,
    HASHES, MERGES
);
support.huaweicloud.com/centralized-devg-v3-gaussdb/gaussdb-12-0530.html