The usual comparison operators are available, as shown in Table 9-1. Table 9-1. Comparison Operators

For enum types (described in Section 8.7), there are several functions that allow cleaner programming

This section describes the SQL-compliant conditional expressions available in PostgreSQL.

The usual logical operators are available: AND OR

This section describes several specialized constructs for making multiple comparisons between groups of values. These forms are syntactically related to the subquery forms

There are three separate approaches to pattern matching provided by PostgreSQL: the traditional SQL

This section describes functions for operating on sequence objects, also called sequence generators or just sequences. Sequence objects are special

This section describes functions that possibly return more than one row. The most widely used functions in this class are series generating functions, as detailed in Table

This section describes the SQL-compliant subquery expressions available in PostgreSQL. All of the expression