- Mastering PostgreSQL 9.6
- Hans Jurgen Schonig
- 223字
- 2021-07-09 19:57:23
Comparing strings
After taking a brief look at the stemming process, it is time to figure out how a stemmed text can be compared to a user query. The following code snippet checks for wanted:
test=# SELECT to_tsvector('english', 'A car, I want a car. I would not even mind having many cars') @@ to_tsquery('english', 'wanted');
?column?
----------
t
(1 row)
Note that wanted does not actually show up in the original text. Still, PostgreSQL will return true. The reason is that want and wanted are both transformed to the same lexeme so the result is true. Practically, this makes a lot of sense. Imagine you are looking for car on Google. If you find pages selling cars, this is totally fine. Finding common lexemes is therefore an intelligent idea.
Sometimes, people are not only looking for a single word but want to find a set of words. With to_tsquery, this is possible as shown in the next example:
test=# SELECT to_tsvector('english', 'A car, I want a car. I would not even mind having many cars') @@ to_tsquery('english', 'wanted & bmw');
?column?
----------
f
(1 row)
In this case, false is returned because bmw cannot be found in our input string. In the to_tsquery function, & means and and | means or. It is therefore easily possible to build complex search strings.
- 數(shù)據(jù)展現(xiàn)的藝術(shù)
- 輕輕松松自動化測試
- Learning Microsoft Azure Storage
- Dreamweaver CS3網(wǎng)頁制作融會貫通
- Mastering VMware vSphere 6.5
- 網(wǎng)絡(luò)組建與互聯(lián)
- Ruby on Rails敏捷開發(fā)最佳實(shí)踐
- Nginx高性能Web服務(wù)器詳解
- 激光選區(qū)熔化3D打印技術(shù)
- 大數(shù)據(jù)案例精析
- Introduction to R for Business Intelligence
- Ansible 2 Cloud Automation Cookbook
- 21天學(xué)通Linux嵌入式開發(fā)
- 納米集成電路制造工藝(第2版)
- 基于Quartus Ⅱ的數(shù)字系統(tǒng)Verilog HDL設(shè)計(jì)實(shí)例詳解