云数据库 GaussDB-CREATE OPERATOR:示例

时间:2023-11-01 16:22:10

示例

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

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-v2-opengauss/devg_03_0559.html