PostgreSQL: Documentation: devel: Chapter 9. Functions and Operators

Documentation → PostgreSQL devel (2025-05-10 03:40:45 - git commit 99ddf8615c2)

Supported Versions: Current (17) / 16 / 15 / 14 / 13

Development Versions: 18 / devel

Unsupported versions: 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3 / 7.2 / 7.1

This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

Chapter 9. Functions and Operators
Prev	Up	Part II. The SQL Language	Home	Next

Chapter 9. Functions and Operators

Table of Contents

9.1. Logical Operators

9.2. Comparison Functions and Operators

9.3. Mathematical Functions and Operators

9.4. String Functions and Operators

9.4.1. format

9.5. Binary String Functions and Operators

9.6. Bit String Functions and Operators

9.7. Pattern Matching

9.7.1. LIKE
9.7.2. SIMILAR TO Regular Expressions
9.7.3. POSIX Regular Expressions

9.8. Data Type Formatting Functions

9.9. Date/Time Functions and Operators

9.9.1. EXTRACT, date_part
9.9.2. date_trunc
9.9.3. date_bin
9.9.4. AT TIME ZONE and AT LOCAL
9.9.5. Current Date/Time
9.9.6. Delaying Execution

9.10. Enum Support Functions

9.11. Geometric Functions and Operators

9.12. Network Address Functions and Operators

9.13. Text Search Functions and Operators