Home
About
Download
Documentation
Community
Developers
Support
Donate
Your account
February 20, 2025:
PostgreSQL 17.4, 16.8, 15.12, 14.17, and 13.20 Released!
Documentation
→
PostgreSQL 12
Supported Versions:
Current
(
17
) /
16
/
15
/
14
/
13
Development Versions:
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.
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