数据仓库服务 GAUSSDB(DWS)-文本检索操作符:||

时间:2024-04-18 16:25:06

||

描述:将两个tsquery类型的词汇进行“或”操作

示例:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
SELECT 'fat | rat'::tsquery || 'cat'::tsquery AS RESULT;
          result           
---------------------------
 ( 'fat' | 'rat' ) | 'cat'
(1 row)
SELECT 'a:1 b:2'::tsvector || 'c:1 d:2 b:3'::tsvector AS RESULT;
          result           
---------------------------
 'a':1 'b':2,5 'c':3 'd':4
(1 row)
support.huaweicloud.com/sqlreference-830-dws/dws_06_0319.html