~

📄字数 419

👁️阅读量 加载中...

功能描述

如果几何体 A 的边界框完全包含几何体 B 的边界框，则 ~ 操作符返回 TRUE。

语法格式

BOOLEAN ~( GEOMETRY A , GEOMETRY B );

参数说明

• A：目标 GEOMETRY 对象。
• B：目标 GEOMETRY 对象。

函数返回类型

BOOLEAN 类型

使用说明

1. 该操作符将利用几何上可能可用的任何索引。

示例

SQL> SELECT tbl1.c1 AS t1_c1, tbl2.c1 AS t2_c1, tbl1.goem ~ tbl2.goem AS contains
        FROM (
        SELECT 1 AS c1, 'LINESTRING(0 0, 3 3)'::GEOMETRY AS goem ) AS tbl1,
        (
        SELECT 2 AS c1, 'LINESTRING(0 0, 4 4)'::GEOMETRY AS goem UNION ALL
        SELECT 3 AS c1, 'LINESTRING(1 1, 2 2)'::GEOMETRY AS goem UNION ALL
        SELECT 4 AS c1, 'LINESTRING(0 0, 3 3)'::GEOMETRY AS goem
        ) AS tbl2;

+-------+-------+----------+
| T1_C1 | T2_C1 | CONTAINS |
+-------+-------+----------+
| 1     | 2     | F        |
| 1     | 3     | T        |
| 1     | 4     | T        |
+-------+-------+----------+

(3 rows)