Historical version. PostgreSQL 7.2 has reached end of support. See the current manual.
II. Server Programming
This second part of the manual explains the PostgreSQL approach to extensibility and describe how users can extend PostgreSQL by adding user-defined types, operators, aggregates, and both query language and programming language functions. After a discussion of the PostgreSQL rule system, we discuss the trigger and SPI interfaces.
- Table of Contents
- 10. Architecture
- 11. Extending SQL: An Overview
- 12. Extending SQL: Functions
- 12.1. Introduction
- 12.2. Query Language (SQL) Functions
- 12.3. Procedural Language Functions
- 12.4. Internal Functions
- 12.5. C Language Functions
- 12.6. Function Overloading
- 12.7. Procedural Language Handlers
- 13. Extending SQL: Types
- 14. Extending SQL: Operators
- 14.1. Introduction
- 14.2. Example
- 14.3. Operator Optimization Information
- 15. Extending SQL: Aggregates
- 16. The Rule System
- 16.1. Introduction
- 16.2. What is a Query Tree?
- 16.3. Views and the Rule System
- 16.4. Rules on INSERT, UPDATE and DELETE
- 16.5. Rules and Permissions
- 16.6. Rules versus Triggers
- 17. Interfacing Extensions To Indexes
- 17.1. Introduction
- 17.2. Access Methods
- 17.3. Access Method Strategies
- 17.4. Access Method Support Routines
- 17.5. Operator Classes
- 17.6. Creating the Operators and Support Routines
- 18. Index Cost Estimation Functions
- 19. GiST Indexes
- 20. Triggers
- 20.1. Trigger Creation
- 20.2. Interaction with the Trigger Manager
- 20.3. Visibility of Data Changes
- 20.4. Examples
- 21. Server Programming Interface
- 21.1. Interface Functions
- 21.2. Interface Support Functions
- 21.3. Memory Management
- 21.4. Visibility of Data Changes
- 21.5. Examples
Report a documentation issue
Read the upstream documentation. For corrections, first check the current manual.