Documentation → PostgreSQL 9.2

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 9.2.24 Documentation
Prev	Up		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 a Command With No Result
39.5.3. Executing a Query with a Single-row Result
39.5.4. Executing Dynamic Commands
39.5.5. Obtaining the Result Status
39.5.6.