<@
功能描述
检查第一个对象是否被包含于第二个对象。
数据类型
L_OPERAND_TYP(左操作数类型) | R_OPERAND_TYP(右操作数类型) | RET_TYPE(返回类型) |
---|---|---|
POINT | BOX | BOOLEAN |
POINT | LSEG | |
POINT | LINE | |
POINT | PATH | |
POINT | POLYGON | |
POINT | CIRCLE | |
BOX | BOX | |
LSEG | BOX | |
LSEG | LINE | |
POLYGON | POLYGON | |
CIRCLE | CIRCLE |
示例
方框被包含
sqlSQL> SELECT BOX(POINT('(0,1)'),POINT('(-1,0)')) <@ BOX(POINT('(1,1)'),POINT('(-1,-1)')); EXPR1 | ------------------------------------------------------------------------------ T | Total 1 records.
圆被包含
sqlSQL> SELECT CIRCLE('<(1,1),2>') <@ CIRCLE('<(0,0),5>') ; EXPR1 | ------------------------------------------------------------------------------ T | Total 1 records.
多边形被包含
sqlSQL> SELECT POLYGON('( 30, 130, 40, 140)') <@ POLYGON('( 10, 110, 20, 120, 30, 130, 40, 140)'); EXPR1 | ------------------------------------------------------------------------------ T | Total 1 records.