Synopsis Description Parameters Examples Compatibility See Also Changes the definition of a text search dictionary. Synopsis ALTER TEXT SEARCH DICTIONARY <name> ( ...
Synopsis Description Parameters Examples Compatibility See Also Removes a text search dictionary. Synopsis DROP TEXT SEARCH DICTIONARY [ IF EXISTS ] <name> [ CASCA...
Synopsis Description Parameters Examples Compatibility See Also Removes a text search configuration. Synopsis DROP TEXT SEARCH CONFIGURATION [ IF EXISTS ] <name> [ ...
Full-text search Match Syntax Example 1: Search the message field for the text “this is a test”: Example 2: Search the message field with the operator parameter: Example 3: S...
Full-text query types and options Query types Match Multi-match Match Boolean prefix Match phrase Match phrase prefix Query string Simple query string Match all Advanced f...
Description Synopsis Description Parameters Compatibility See Also Description Defines a new text search parser. Synopsis CREATE TEXT SEARCH PARSER name ( START =...
Configuration Testing Parser Testing Dictionary Testing This topic introduces the Greenplum Database functions you can use to test and debug a search configuration or the indiv...
Manipulating Documents Manipulating Queries Rewriting Queries Gathering Document Statistics Greenplum Database has additional functions and operators you can use to manipulate...
Searching a Table Creating Indexes This topic shows how to use text search operators to search database tables and how to create indexes to speed up text searches. The examples...
Full-text search Match Syntax Example 1: Search the message field for the text “this is a test”: Example 2: Search the message field with the operator parameter: Example 3: S...