Chapter 39. PL/pgSQL — SQL Procedural Language#

Chapter 39. PL/pgSQL — SQL Procedural Language
Chapter 39. PL/pgSQL — SQL Procedural Language
Prev UpPart V. Server ProgrammingHome Next

Chapter 39. PL/pgSQL — SQL Procedural Language

Table of Contents

39.1. Overview
39.1.1. Advantages of Using PL/pgSQL
39.1.2. Supported Argument and Result Data Types
39.2. Structure of PL/pgSQL
39.3. Declarations
39.3.1. Declaring Function Parameters
39.3.2. ALIAS
39.3.3. Copying Types
39.3.4. Row Types
39.3.5. Record Types
39.3.6. Collation of PL/pgSQL Variables
39.4. Expressions
39.5. Basic Statements
39.5.1. Assignment
39.5.2. Executing SQL Commands
39.5.3. Executing a Command with a Single-Row Result
39.5.4. Executing Dynamic Commands
39.5.5. Obtaining the Result Status
39.5.6. Doing Nothing At All
39.6. Control Structures
39.6.1. Returning from a Function
39.6.2. Returning from a Procedure
39.6.3. Calling a Procedure
39.6.4. Conditionals
39.6.5. Simple Loops
39.6.6. Looping through Query Results
39.6.7. Looping through Arrays
39.6.8. Trapping Errors
39.6.9. Obtaining Execution Location Information
39.7. Cursors
39.7.1. Declaring Cursor Variables
39.7.2. Opening Cursors
39.7.3. Using Cursors
39.7.4. Looping through a Cursor's Result
39.8. Transaction Management
39.9. Errors and Messages
39.9.1. Reporting Errors and Messages
39.9.2. Checking Assertions
39.10. Trigger Functions
39.10.1. Triggers on Data Changes
39.10.2. Triggers on Events
39.11. PL/pgSQL under the Hood
39.11.1. Variable Substitution
39.11.2. Plan Caching
39.12. Tips for Developing in PL/pgSQL
39.12.1. Handling of Quotation Marks
39.12.2. Additional Compile-Time and Run-Time Checks
39.13. Porting from Oracle PL/SQL
39.13.1. Porting Examples
39.13.2. Other Things to Watch For
39.13.3. Appendix
Prev Up Next
38.1. Installing Procedural Languages Home 39.1. Overview