The examples in the previous section illustrated full text matching using simple constant strings. This section shows how to search table data, optionally using indexes.

There are two kinds of indexes that can be used to speed up full text searches. Note that indexes are not mandatory for full text searching, but in cases where a column is

The behavior of a custom text search configuration can easily become confusing. The functions described in this section are useful for testing text search objects. You can

This section describes additional functions and operators that are useful in connection with text search. 12

A text search configuration specifies all options necessary to transform a document into a tsvector: the parser to use to break text into tokens,

Full Text Searching (or just text search) provides the capability to identify natural-language documents that satisfy a

To implement full text searching there must be a function to create a tsvector from a document and a tsquery from a user

The current limitations of PostgreSQL's text search features are: The

Information about text search configuration objects can be obtained in psql using a set of commands:

Text search parsers are responsible for splitting raw document text into tokens and identifying each token's type, where the set of possible types