Home
About
Download
Documentation
Community
Developers
Support
Donate
Your account
May 8, 2025:
PostgreSQL 17.5, 16.9, 15.13, 14.18, and 13.21 Released!
|
PostgreSQL 18 Beta 1 Released!
Documentation
→
PostgreSQL 9.1
Supported Versions:
Current
(
17
) /
16
/
15
/
14
/
13
Development Versions:
18
/
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.
PostgreSQL 9.1.24 Documentation
Prev
Up
Next
Chapter 35. Extending
SQL
Table of Contents
35.1.
How Extensibility Works
35.2.
The
PostgreSQL
Type System
35.2.1.
Base Types
35.2.2.
Composite Types
35.2.3.
Domains
35.2.4.
Pseudo-Types
35.2.5.
Polymorphic Types
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.4.11.
SQL
Functions with Collations
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.
Compiling and Linking Dynamically-loaded Functions
35.9.7.
Composite-type Arguments
35.9.8.