Documentation → PostgreSQL 7.3

Supported Versions: Current (17) / 16 / 15 / 14 / 13

Development Versions: 18 / devel

Unsupported versions: 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3 / 7.2 / 7.1

This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

PostgreSQL 7.3.21 Documentation
Prev		Next

Chapter 19. PL/pgSQL - SQL Procedural Language

Table of Contents

19.1. Overview

19.1.1. Advantages of Using PL/pgSQL
19.1.2. Developing in PL/pgSQL

19.2. Structure of PL/pgSQL

19.3. Declarations

19.3.1. Aliases for Function Parameters
19.3.2. Row Types
19.3.3. Records
19.3.4. Attributes
19.3.5. RENAME

19.4. Expressions

19.5. Basic Statements

19.5.1. Assignment
19.5.2. SELECT INTO
19.5.3. Executing an expression or query with no result
19.5.4. Executing dynamic queries
19.5.5. Obtaining result status

19.6. Control Structures

19.6.1. Returning from a function
19.6.2. Conditionals
19.6.3. Simple Loops
19.6.4. Looping Through Query Results

19.7. Cursors

19.7.1. Declaring Cursor Variables
19.7.2. Opening Cursors
19.7.3. Using Cursors

19.8. Errors and Messages

19.9. Trigger Procedures

19.10. Examples

19.11. Porting from Oracle PL/SQL

19.11.1. Main Differences
19.11.2.