Using Full Text Search

SynxDB provides data types, functions, operators, index types, and configurations for querying natural language documents.

• About Full Text Search
  This topic provides an overview of SynxDB full text search, basic text search expressions, configuring, and customizing text search.
• Searching Text in Database Tables
  This topic shows how to use text search operators to search database tables and how to create indexes to speed up text searches.
• Controlling Text Search
  This topic shows how to create search and query vectors, how to rank search results, and how to highlight search terms in the results of text search queries.
• Additional Text Search Features
  SynxDB has additional functions and operators you can use to manipulate search and query vectors, and to rewrite search queries.
• Text Search Parser
  This topic describes the types of tokens the SynxDB text search parser produces from raw text.
• Text Search Dictionaries
  Tokens produced by the SynxDB full text search parser are passed through a chain of dictionaries to produce a normalized term or “lexeme”. Different kinds of dictionaries are available to filter and transform tokens in different ways and for different languages.
• Text Search Configuration Example
  This topic shows how to create a customized text search configuration to process document and query text.
• Testing and Debugging Text Search
  This topic introduces the SynxDB functions you can use to test and debug a search configuration or the individual parser and dictionaries specified in a configuration.
• GiST and GIN Indexes for Text Search
  This topic describes and compares the SynxDB index types that are used for full text searching.
• psql Support
  The psql command-line utility provides a meta-command to display information about SynxDB full text search configurations.
• Limitations
  This topic lists limitations and maximums for SynxDB full text search objects.