Chapter 35. 扩展SQL
- Table of Contents
- 35.1. 扩展性是如何实现的
- 35.2.
PostgreSQL类型系统
- 35.2.1. 基本类型
- 35.2.2. 复合类型
- 35.2.3. 域
- 35.2.4. 伪类型
- 35.2.5. 多态类型
- 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. 编译连接动态加载函数
- 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. 用户自定义类型
- 35.12. User-Defined Operators
- 35.13. Operator Optimization Information
- 35.13.1. COMMUTATOR
- 35.13.2. NEGATOR
- 35.13.3. RESTRICT
- 35.13.4. JOIN
- 35.13.5. HASHES
- 35.13.6. MERGES
- 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. 用C++扩展
在本章的剩余部分,我们将讨论你如何通过增加下面几种对象来扩展
PostgreSQL的SQL查询语言: