Postgres Pro Standard : Documentation: 16: Chapter 42. PL/pgSQL — SQL Procedural Language : Postgres Professional

Content-Length: 97637 | pFad | http://postgrespro.com/docs/postgrespro/16/plpgsql

Postgres Pro Standard : Documentation: 16: Chapter 42. PL/pgSQL — SQL Procedural Language : Postgres Professional

Chapter 42. PL/pgSQL — SQL Procedural Language
Prev	Up	Part V. Server Programming	Home	Next

Chapter 42. PL/pgSQL — SQL Procedural Language

Table of Contents

42.1. Overview

42.1.1. Advantages of Using PL/pgSQL
42.1.2. Supported Argument and Result Data Types

42.2. Structure of PL/pgSQL

42.3. Declarations

42.3.1. Declaring Function Parameters
42.3.2. ALIAS
42.3.3. Copying Types
42.3.4. Row Types
42.3.5. Record Types
42.3.6. Collation of PL/pgSQL Variables

42.4. Expressions

42.5. Basic Statements

42.5.1. Assignment
42.5.2. Executing SQL Commands
42.5.3. Executing a Command with a Single-Row Result
42.5.4. Executing Dynamic Commands
42.5.5. Obtaining the Result Status
42.5.6. Doing Nothing At All

42.6. Control Structures

42.6.1. Returning from a Function
42.6.2. Returning from a Procedure
42.6.3. Calling a Procedure
42.6.4. Conditionals
42.6.5. Simple Loops
42.6.6. Looping through Query Results
42.6.7. Looping through Arrays
42.6.8. Trapping Errors
42.6.9. Obtaining Execution Location Information

42.7. Cursors

42.7.1. Declaring Cursor Variables
42.7.2. Opening Cursors
42.7.3. Using Cursors
42.7.4. Looping through a Cursor's Result

42.8. Transaction Management

42.9. Errors and Messages

42.9.1. Reporting Errors and Messages
42.9.2. Checking Assertions

42.10. Trigger Functions

42.10.1. Triggers on Data Changes
42.10.2. Triggers on Events

42.11. PL/pgSQL under the Hood

42.11.1. Variable Substitution
42.11.2. Plan Caching

42.12. Tips for Developing in PL/pgSQL

42.12.1. Handling of Quotation Marks
42.12.2. Additional Compile-Time and Run-Time Checks

42.13. Porting from Oracle PL/SQL

42.13.1. Porting Examples
42.13.2. Other Things to Watch For
42.13.3. Appendix

Prev	Up	Next
41.1. Installing Procedural Languages	Home	42.1. Overview

pdf epub