PostgreSQL: Documentation: 11: Chapter 38. Extending SQL

Documentation → PostgreSQL 11

Supported Versions: Current (17) / 16 / 15 / 14 / 13

Development Versions: devel

Unsupported versions: 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3 / 7.2 / 7.1

This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

Chapter 38. Extending SQL
Prev	Up	Part V. Server Programming	Home	Next

Chapter 38. Extending SQL

Table of Contents

38.1. How Extensibility Works

38.2. The PostgreSQL Type System

38.2.1. Base Types
38.2.2. Container Types
38.2.3. Domains
38.2.4. Pseudo-Types
38.2.5. Polymorphic Types

38.3. User-defined Functions

38.4. User-defined Procedures

38.5. Query Language (SQL) Functions

38.5.1. Arguments for SQL Functions
38.5.2. SQL Functions on Base Types
38.5.3. SQL Functions on Composite Types
38.5.4. SQL Functions with Output Parameters
38.5.5. SQL Functions with Variable Numbers of Arguments
38.5.6. SQL Functions with Default Values for Arguments
38.5.7. SQL Functions as Table Sources
38.5.8. SQL Functions Returning Sets
38.5.9. SQL Functions Returning TABLE
38.5.10. Polymorphic SQL Functions
38.5.11. SQL Functions with Collations

38.6. Function Overloading

38.7. Function Volatility Categories

38.8. Procedural Language Functions

38.9. Internal Functions

38.10. C-Language Functions

38.10.1. Dynamic Loading
38.10.2. Base Types in C-Language Functions
38.10.3. Version 1 Calling Conventions
38.10.4. Writing Code