Documentation → PostgreSQL 9.3

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

Development Versions: 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.

PostgreSQL 9.3.25 Documentation
Prev	Up		Next

Chapter 9. Functions and Operators

Table of Contents

9.1. Logical Operators

9.2. Comparison Operators

9.3. Mathematical Functions and Operators

9.4. String Functions and Operators

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. AT TIME ZONE
9.9.4. Current Date/Time
9.9.5. 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. XML Functions

9.14.1. Producing XML Content
9.14.2. XML Predicates
9.14.3. Processing XML
9.14.4. Mapping Tables to XML

9.15. JSON Functions and Operators

9.16. Sequence Manipulation Functions

9.17. Conditional Expressions

9.17.1. CASE
9.17.2. COALESCE
9.17.3. NULLIF
9.17.4. GREATEST and LEAST

9.18. Array Functions and Operators

9.19. Range Functions and Operators

9.20. Aggregate Functions

9.21. Window Functions

9.22. Subquery Expressions

9.22.1. EXISTS
9.22.2. IN
9.22.3. NOT IN
9.22.4.