Movatterモバイル変換

Table of Contents

36.1. How Extensibility Works

36.2. ThePostgres Pro Type System

36.2.1. Base Types

36.2.2. Container Types

36.2.3. Domains

36.2.4. Pseudo-Types

36.2.5. Polymorphic Types

36.3. User-Defined Functions

36.4. User-Defined Procedures

36.5. Query Language (SQL) Functions

36.5.1. Arguments forSQL 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 Procedures with Output Parameters

36.5.6.SQL Functions with Variable Numbers of Arguments

36.5.7.SQL Functions with Default Values for Arguments

36.5.8.SQL Functions as Table Sources

36.5.9.SQL Functions Returning Sets

36.5.10.SQL Functions ReturningTABLE

36.5.11. PolymorphicSQL Functions

36.5.12.SQL Functions with Collations

36.6. Function Overloading

36.7. Function Volatility Categories

36.8. Procedural Language Functions

36.9. Internal Functions

36.10. C-Language Functions

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. Shared Memory

36.10.11. LWLocks

36.10.12. Custom Wait Events

36.10.13. Injection Points

36.10.14. Using C++ for Extensibility

36.11. Function Optimization Information

36.12. User-Defined Aggregates

36.12.1. Moving-Aggregate Mode

36.12.2. Polymorphic and Variadic Aggregates

36.12.3. Ordered-Set Aggregates

36.12.4. Partial Aggregation

36.12.5. Support Functions for Aggregates

36.13. User-Defined Types

36.14. User-Defined Operators

36.15. Operator Optimization Information

36.15.1.COMMUTATOR

36.15.2.NEGATOR

36.15.3.RESTRICT

36.15.4.JOIN

36.15.5.HASHES

36.15.6.MERGES

36.16. Interfacing Extensions to Indexes

36.16.1. Index Methods and Operator Classes

36.16.2. Index Method Strategies

36.16.3. Index Method Support Routines

36.16.4. An Example

36.16.5. Operator Classes and Operator Families

36.16.6. System Dependencies on Operator Classes

36.16.7. Ordering Operators

36.16.8. Special Features of Operator Classes

36.17. Packaging Related Objects into an Extension

36.17.1. Extension Files

36.17.2. Extension Relocatability

36.17.3. Extension Configuration Tables

36.17.4. Extension Updates

36.17.5. Installing Extensions Using Update Scripts

36.17.6. Security Considerations for Extensions

36.17.7. Extension Example

36.18. Extension Building Infrastructure

• functions (starting inSection 36.3)

• aggregates (starting inSection 36.12)

• data types (starting inSection 36.13)

• operators (starting inSection 36.14)

• operator classes for indexes (starting inSection 36.16)

• packages of related objects (starting inSection 36.17)