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

May 8, 2025: PostgreSQL 17.5, 16.9, 15.13, 14.18, and 13.21 Released! | PostgreSQL 18 Beta 1 Released!

Documentation → PostgreSQL 15

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

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
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

9.14. UUID Functions

9.15. XML Functions

9.15.1. Producing XML Content
9.15.2. XML Predicates
9.15.3. Processing XML
9.15.4. Mapping Tables to XML

9.16. JSON Functions and Operators

9.16.1. Processing and Creating JSON Data
9.16.2. The SQL/JSON Path Language

9.17. Sequence Manipulation Functions

9.18. Conditional Expressions

9.18.1. CASE