Skip to content

<@

功能描述

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

数据类型

L_OPERAND_TYP(左操作数类型)R_OPERAND_TYP(右操作数类型)RET_TYPE(返回类型)
POINTBOXBOOLEAN
POINTLSEG
POINTLINE
POINTPATH
POINTPOLYGON
POINTCIRCLE
BOXBOX
LSEGBOX
LSEGLINE
POLYGONPOLYGON
CIRCLECIRCLE

示例

  • 方框被包含

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

    sql
    SQL> SELECT CIRCLE('<(1,1),2>') <@ CIRCLE('<(0,0),5>') ;
    
    EXPR1 |
    ------------------------------------------------------------------------------
    T |
    
    Total 1 records.
  • 多边形被包含

    sql
    SQL> SELECT POLYGON('(  30, 130, 40, 140)') <@ POLYGON('( 10, 110, 20, 120, 30, 130, 40, 140)');
    
    EXPR1 |
    ------------------------------------------------------------------------------
    T |
    
    Total 1 records.