Table 9-30 shows the available functions for date/time value processing, with details appearing in the following subsections. Table 9-29 illustrates the behaviors of the basic

NameALTER OPERATOR -- change the definition of an operator Synopsis

Authentication failures and related problems generally manifest themselves through error messages like the following:

Functions and triggers allow users to insert code into the backend server that other users might execute unintentionally. Hence, both mechanisms permit users to "Trojan

Databases are destroyed with the command DROP DATABASE:

The pg_visibility module provides a means for examining the visibility map (VM) and page-level visibility information. It also provides functions

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.

NameDROP SERVER -- remove a foreign server descriptor Synopsis

unaccent is a text search dictionary that removes accents (diacritic signs) from lexemes. It's a filtering dictionary, which means its output

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