PostgreSQL 8.2.9 Documentation
Prev	Fast Backward		Fast Forward	Next

V. Server Programming

This part is about extending the server functionality with user-defined functions, data types, triggers, etc. These are advanced topics which should probably be approached only after all the other user documentation about PostgreSQL has been understood. Later chapters in this part describe the server-side programming languages available in the PostgreSQL distribution as well as general issues concerning server-side programming languages. It is essential to read at least the earlier sections of Chapter 33 (covering functions) before diving into the material about server-side programming languages.

Table of Contents

33. Extending SQL

33.1. How Extensibility Works
33.2. The PostgreSQL Type System
33.3. User-Defined Functions
33.4. Query Language (SQL) Functions
33.5. Function Overloading
33.6. Function Volatility Categories
33.7. Procedural Language Functions
33.8. Internal Functions
33.9. C-Language Functions
33.10. User-Defined Aggregates
33.11. User-Defined Types
33.12. User-Defined Operators
33.13. Operator Optimization Information
33.14. Interfacing Extensions To Indexes

34. Triggers

34.1. Overview of Trigger Behavior
34.2. Visibility of Data Changes
34.3. Writing Trigger Functions in C
34.4. A Complete Example

35. The Rule System

35.1. The Query Tree
35.2. Views and the Rule System
35.3. Rules on INSERT, UPDATE, and DELETE
35.4. Rules and Privileges
35.5. Rules and Command Status
35.6. Rules versus Triggers

36. Procedural Languages

36.1. Installing Procedural Languages

37. PL/pgSQL - SQL Procedural Language

37.1. Overview
37.2. Tips for Developing in PL/pgSQL
37.3. Structure of PL/pgSQL
37.4. Declarations
37.5. Expressions
37.6. Basic Statements
37.7. Control Structures
37.8. Cursors
37.9. Errors and Messages
37.10. Trigger Procedures
37.11. Porting from Oracle PL/SQL

38. PL/Tcl - Tcl Procedural Language

38.1. Overview
38.2. PL/Tcl Functions and Arguments
38.3. Data Values in PL/Tcl
38.4. Global Data in PL/Tcl
38.5. Database Access from PL/Tcl
38.6. Trigger Procedures in PL/Tcl
38.7. Modules and the unknown command
38.8. Tcl Procedure Names

39. PL/Perl - Perl Procedural Language

39.1. PL/Perl Functions and Arguments
39.2. Database Access from PL/Perl
39.3. Data Values in PL/Perl
39.4. Global Values in PL/Perl
39.5. Trusted and Untrusted PL/Perl
39.6. PL/Perl Triggers
39.7. Limitations and Missing Features

40. PL/Python - Python Procedural Language

40.1. PL/Python Functions
40.2. Trigger Functions
40.3. Database Access

41. Server Programming Interface

41.1. Interface Functions
41.2. Interface Support Functions
41.3. Memory Management
41.4. Visibility of Data Changes
41.5. Examples

Prev	Home	Next
`views`		Extending SQL