Historical version. PostgreSQL 9.0 has reached end of support. 2015-10-08. See the current manual.
Chapter 35. Extending SQL
- Table of Contents
- 35.1. How Extensibility Works
- 35.2. The PostgreSQL Type System
- 35.2.1. Base Types
- 35.2.2. Composite Types
- 35.2.3. Domains
- 35.2.4. Pseudo-Types
- 35.2.5. Polymorphic Types
- 35.3. User-Defined Functions
- 35.4. Query Language (SQL) Functions
- 35.4.1. SQL Functions on Base Types
- 35.4.2. SQL Functions on Composite Types
- 35.4.3. SQL Functions with Parameter Names
- 35.4.4. SQL Functions with Output Parameters
- 35.4.5. SQL Functions with Variable Numbers of Arguments
- 35.4.6. SQL Functions with Default Values for Arguments
- 35.4.7. SQL Functions as Table Sources
- 35.4.8. SQL Functions Returning Sets
- 35.4.9. SQL Functions Returning TABLE
- 35.4.10. Polymorphic SQL Functions
- 35.5. Function Overloading
- 35.6. Function Volatility Categories
- 35.7. Procedural Language Functions
- 35.8. Internal Functions
- 35.9. C-Language Functions
- 35.9.1. Dynamic Loading
- 35.9.2. Base Types in C-Language Functions
- 35.9.3. Version 0 Calling Conventions
- 35.9.4. Version 1 Calling Conventions
- 35.9.5. Writing Code
- 35.9.6. Compiling and Linking Dynamically-Loaded Functions
- 35.9.7. Extension Building Infrastructure
- 35.9.8. Composite-Type Arguments
- 35.9.9. Returning Rows (Composite Types)
- 35.9.10. Returning Sets
- 35.9.11. Polymorphic Arguments and Return Types
- 35.9.12. Shared Memory and LWLocks
- 35.10. User-Defined Aggregates
- 35.11. User-Defined Types
- 35.12. User-Defined Operators
- 35.13. Operator Optimization Information
- 35.14. Interfacing Extensions To Indexes
- 35.14.1. Index Methods and Operator Classes
- 35.14.2. Index Method Strategies
- 35.14.3. Index Method Support Routines
- 35.14.4. An Example
- 35.14.5. Operator Classes and Operator Families
- 35.14.6. System Dependencies on Operator Classes
- 35.14.7. Special Features of Operator Classes
- 35.15. Using C++ for Extensibility
In the sections that follow, we will discuss how you can extend the PostgreSQL SQL query language by adding:
functions (starting in Section 35.3)
aggregates (starting in Section 35.10)
data types (starting in Section 35.11)
operators (starting in Section 35.12)
operator classes for indexes (starting in Section 35.14)
Report a documentation issue
Read the upstream documentation. For corrections, first check the current manual.