数智融合计算服务 DATAARTSFABRIC-文本检索操作符:||
时间:2025-06-17 08:50:05
||
描述:将两个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/devg-fabric/dataartsfabric_sql_04_0233.html