Skip to content

@>

功能描述

检查第一个对象是否包含第二个对象。

数据类型

L_OPERAND_TYP(左操作数类型)R_OPERAND_TYP(右操作数类型)RET_TYPE(返回类型)
BOXPOINTBOOLEAN
BOXBOX
PATHPOINT
POLYGONPOINT
POLYGONPOLYGON
CIRCLEPOINT
CIRCLECIRCLE

示例

  • 方框不包含

    sql
    SQL> SELECT BOX(POINT('(0,1)'),POINT('(1,0)')) @> BOX(POINT('(0,1)'),POINT('(-1,0)'));
    
    EXPR1 |
    ------------------------------------------------------------------------------
    F |
    
    Total 1 records.
  • 圆包含点

    sql
    SQL> SELECT CIRCLE('<(0,0),2>') @> POINT('(1,1)');
    
    EXPR1 |
    ------------------------------------------------------------------------------
    T |
    
    Total 1 records.