Help Center/ GaussDB/ Developer Guide(Centralized_2.x)/ SQL Reference/ Full Text Search/ Additional Features/ Manipulating Queries
Updated on 2023-10-23 GMT+08:00
View PDF
Share

Manipulating Queries

GaussDB provides functions and operators that can be used to manipulate queries that are already in tsquery type.

  • tsquery && tsquery

    Returns the AND-combination of the two given queries.

  • tsquery || tsquery

    Returns the OR-combination of the two given queries.

  • !! tsquery

    Returns the negation (NOT) of the given query.

  • numnode(query tsquery) returns integer

    Returns the number of nodes (lexemes plus operators) in a tsquery. This function is useful to determine if the query is meaningful (returns > 0), or contains only stop words (returns 0). Example:

     1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
    		 
    openGauss=# SELECT numnode(plainto_tsquery('the any'));
NOTICE:  text-search query contains only stop words or doesn't contain lexemes, ignored
CONTEXT:  referenced column: numnode
 numnode 
---------
       0

openGauss=# SELECT numnode('foo & bar'::tsquery);
 numnode
---------
       3
  • querytree(query tsquery) returns text

    Returns the portion of a tsquery that can be used for searching an index. This function is useful for detecting non-index queries, for example those containing only stop words or only negated terms. Example:

    1
2
3
4
5
    		 
    openGauss=# SELECT querytree(to_tsquery('!defined'));
 querytree 
-----------
 T
(1 row)
Parent topic: Additional Features