Table 9-39, Table 9-40 and Table 9-41 summarize the functions and operators that are provided for full text searching. See Chapter 12 for a detailed explanation of

The functions and function-like expressions described in this section operate on values of type xml. Check

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

Currently PostgreSQL provides one built in trigger function, suppress_redundant_updates_trigger, which will prevent

Table 9-36 shows the operators available for the cidr and inet types. The operators <<

PostgreSQL provides these helper functions to retrieve information from event triggers. For more information

Table 9-47 shows the operators available for array types. Table 9-47. Array Operators

Table 9-42 shows the operators that are available for use with the two JSON data types (see Section 8.14)

Mathematical operators are provided for many PostgreSQL types. For types without standard mathematical conventions (e.g., date/time types)

The functions described in this section are used to control and monitor a PostgreSQL installation.