Postgres-XC 0.9.7 Documentation
PrevFast BackwardFast ForwardNext

Chapter 38. PL/pgSQL - SQL Procedural Language

Table of Contents
38.1. Overview
38.1.1. Advantages of Using PL/pgSQL
38.1.2. Supported Argument and Result Data Types
38.2. Structure of PL/pgSQL
38.3. Declarations
38.3.1. Declaring Function Parameters
38.3.2. ALIAS
38.3.3. Copying Types
38.3.4. Row Types
38.3.5. Record Types
38.3.6. Collation of PL/pgSQL Variables
38.4. Expressions
38.5. Basic Statements
38.5.1. Assignment
38.5.2. Executing a Command With No Result
38.5.3. Executing a Query with a Single-row Result
38.5.4. Executing Dynamic Commands
38.5.5. Obtaining the Result Status
38.5.6. Doing Nothing At All
38.6. Control Structures
38.6.1. Returning From a Function
38.6.2. Conditionals
38.6.3. Simple Loops
38.6.4. Looping Through Query Results
38.6.5. Looping Through Arrays
38.6.6. Trapping Errors
38.7. Cursors
38.7.1. Declaring Cursor Variables
38.7.2. Opening Cursors
38.7.3. Using Cursors
38.7.4. Looping Through a Cursor's Result
38.8. Errors and Messages
38.9. Trigger Procedures
38.10. PL/pgSQL Under the Hood
38.10.1. Variable Substitution
38.10.2. Plan Caching
38.11. Tips for Developing in PL/pgSQL
38.12. Porting from Oracle PL/SQL
38.12.1. Porting Examples
38.12.2. Other Things to Watch For
38.12.3. Appendix
PrevHomeNext
Installing Procedural LanguagesUpOverview