PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Documentation → PostgreSQL 7.1

Unsupported versions: 7.3 / 7.2 / 7.1

Historical version. PostgreSQL 7.1 has reached end of support. See the current manual.

II. Server Programming

Table of Contents

11. Architecture

11.1. Postgres Architectural Concepts

12. Extending SQL: An Overview

12.1. How Extensibility Works
12.2. The Postgres Type System
12.3. About the Postgres System Catalogs

13. Extending SQL: Functions

13.1. Query Language (SQL) Functions
13.2. Procedural Language Functions
13.3. Internal Functions
13.4. Compiled (C) Language Functions
13.5. Function Overloading

14. Extending SQL: Types

14.1. User-Defined Types

15. Extending SQL: Operators

15.1. Operator Optimization Information

16. Extending SQL: Aggregates

17. The Postgres Rule System

17.1. What is a Querytree?
17.2. Views and the Rule System
17.3. Rules on INSERT, UPDATE and DELETE
17.4. Rules and Permissions
17.5. Rules versus Triggers

18. Interfacing Extensions To Indices

19. Index Cost Estimation Functions

20. GiST Indices

21. Triggers

21.1. Trigger Creation
21.2. Interaction with the Trigger Manager
21.3. Visibility of Data Changes
21.4. Examples

22. Server Programming Interface

22.1. Interface Functions
22.2. Interface Support Functions
22.3. Memory Management
22.4. Visibility of Data Changes
22.5. Examples

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.