Chapter 36. Extending SQL
Table of Contents
- 36.1. How Extensibility Works
- 36.2. The Postgres Pro Type System
- 36.3. User-defined Functions
- 36.4. User-defined Procedures
- 36.5. Query Language (SQL) Functions
- 36.4. User-defined Procedures
- 36.5.1. Arguments for SQL Functions
- 36.5.2. SQL Functions on Base Types
- 36.5.3. SQL Functions on Composite Types
- 36.5.4. SQL Functions with Output Parameters
- 36.5.5. SQL Functions with Variable Numbers of Arguments
- 36.5.6. SQL Functions with Default Values for Arguments
- 36.5.7. SQL Functions as Table Sources
- 36.5.8. SQL Functions Returning Sets
- 36.5.9. SQL Functions Returning
TABLE- 36.5.10. Polymorphic SQL Functions
- 36.5.11. SQL Functions with Collations
- 36.5.2. SQL Functions on Base Types
- 36.5.1. Arguments for SQL Functions
- 36.6. Function Overloading
- 36.7. Function Volatility Categories
- 36.8. Procedural Language Functions
- 36.9. Internal Functions
- 36.10. C-Language Functions
- 36.7. Function Volatility Categories
- 36.10.1. Dynamic Loading
- 36.10.2. Base Types in C-Language Functions
- 36.10.3. Version 1 Calling Conventions
- 36.10.4. Writing Code
- 36.10.5. Compiling and Linking Dynamically-loaded Functions
- 36.10.6. Composite-type Arguments
- 36.10.7. Returning Rows (Composite Types)
- 36.10.8. Returning Sets
- 36.10.9. Polymorphic Arguments and Return Types
- 36.10.10. Transform Functions
- 36.10.11. Shared Memory and LWLocks
- 36.10.12. Using C++ for Extensibility
- 36.10.2. Base Types in C-Language Functions
- 36.10.1. Dynamic Loading
- 36.11. User-defined Aggregates
- 36.12. User-defined Types
- 36.13. User-defined Operators
- 36.14. Operator Optimization Information
- 36.13. User-defined Operators
- 36.15. Interfacing Extensions To Indexes
- 36.16. Packaging Related Objects into an Extension
- 36.17. Extension Building Infrastructure
In the sections that follow, we will discuss how you can extend the Postgres Pro SQL query language by adding:
functions (starting in Section 36.3)
aggregates (starting in Section 36.11)
data types (starting in Section 36.12)
operators (starting in Section 36.13)
operator classes for indexes (starting in Section 36.15)
packages of related objects (starting in Section 36.16)