Using the stored procedural language v15

Suggest edits

EDB Postgres Advanced Server's stored procedural language (SPL) is a highly productive, procedural programming language for writing custom procedures, functions, triggers, and packages for EDB Postgres Advanced Server. It provides:

  • Full procedural programming functionality to complement the SQL language
  • A single, common language to create stored procedures, functions, triggers, and packages for the EDB Postgres Advanced Server database
  • A seamless development and testing environment
  • The use of reusable code
  • Ease of use

For reference information about the SPL program types, programming statements, control structures, collection types, and collection methods, see Stored procedural language (SPL) reference.

Types of SPL programs

Using variable declarations

Working with transactions

Using dynamic SQL

Working with static cursors

Working with REF CURSOR and cursor variables

Working with collection types

Working with collections

Working with triggers

Working with packages

Using object types and objects

← Prev

Including embedded SQL commands

Next →

Types of SPL programs