For enum types (described in Section 8.7), there are several functions that allow cleaner programming
The usual comparison operators are available, as shown in Table 9-1. Table 9-1. Comparison Operators
This section describes the SQL-compliant conditional expressions available in PostgreSQL.
There are three separate approaches to pattern matching provided by PostgreSQL: the traditional SQL
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
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