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

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

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

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

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

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

Dictionaries are used to eliminate words that should not be considered in a search (stop words), and to normalize words so