Glossary: PostgreSQL Beyond the Basics
tsvector, tsquery
Also written: tsvector, tsquery, to_tsvector(), to_tsquery()
A tsvector is a searchable list of lexemes with positions. A tsquery is a search made of words joined by `&`, `|`, `!` and `<->`.
Where the book teaches it
Related terms
Lexeme, stemming, stop wordswebsearch_to_tsquery()@@ (text search match operator)