Binary String Functions and Operators
  • References/Database/PostgreSQL/Functions/Binary String

This section describes functions and operators for examining and manipulating values of type bytea.

2025-01-10 15:47:30
Window Functions
  • References/Database/PostgreSQL/Functions/Window

Window functions provide the ability to perform calculations across sets of rows that are related to the current query row. See

2025-01-10 15:47:30
Formatting Functions
  • References/Database/PostgreSQL/Functions/Data Type Formatting

The PostgreSQL formatting functions provide a powerful set of tools for converting various data types (date/time, integer, floating point,

2025-01-10 15:47:30
Aggregate Functions
  • References/Database/PostgreSQL/Functions/Aggregate

Aggregate functions compute a single result from a set of input values. The built-in normal aggregate functions are listed in Table 9-51 and Table

2025-01-10 15:47:30
Information Functions
  • References/Database/PostgreSQL/Functions/System Information

Table 9-59 shows several functions that extract session and system information. In addition to the functions listed in this section, there are

2025-01-10 15:47:30
Bit String Functions and Operators
  • References/Database/PostgreSQL/Functions/Bit String

This section describes functions and operators for examining and manipulating bit strings, that is values of the types bit and bit

2025-01-10 15:47:30
Geometric Functions and Operators
  • References/Database/PostgreSQL/Functions/Geometric

The geometric types point, box, lseg, line, path

2025-01-10 15:47:30
String Functions and Operators
  • References/Database/PostgreSQL/Functions/String

This section describes functions and operators for examining and manipulating string values. Strings in this context include values of the types character

2025-01-10 15:47:30
Range Functions and Operators
  • References/Database/PostgreSQL/Functions/Range

See Section 8.17 for an overview of range types. Table 9-49 shows

2025-01-10 15:47:30