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

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

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

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

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

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

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

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

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

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