#openGauss #入门 #安装 #数据库 #开源
知识来源：docs-opengauss.osinfra.cn/zh/
像America这样的相关词也会被找到，因为这些词都被处理成了相同标准的词条。
上面的查询指定english配置来解析和规范化字符串。当然也可以省略此配置，通过default_text_search_config进行配置设置：
openGauss=# SHOW default_text_search_config; default_text_search_config —————————- pg_catalog.english (1 row)
openGauss=# SELECT id, body, title FROM tsearch.pgweb WHERE to_tsvector(body) @@ to_tsquery('america');
id | body | title
----+-------------------------------------------------------------------------------------------------------------------------+---------
11 | Brazil, officially the Federative Republic of Brazil, is the largest country in both South America and Latin America. | Brazil
2 | America is a rock band, formed in England in 1970 by multi-instrumentalists Dewey Bunnell, Dan Peek, and Gerry Beckley. | America
12 | Canada is a country in the northern half of North America. | Canada
13 | Mexico, officially the United Mexican States, is a federal republic in the southern part of North America. | Mexico
(4 rows)
```
#openGauss #入门 #安装 #数据库 #开源
