PostgreSQL Tutorial: PL/pgSQL
This section shows you step by step how to use the PL/pgSQL to develop PostgreSQL user-defined functions and stored procedures.
PostgreSQL Tutorial: PL/pgSQL Function Returns SetOf
Summary: In this tutorial, you will learn how to use the returns setof option to define a function that returns one or more rows.
PostgreSQL Tutorial: Stored Procedure with INOUT Parameters
Summary: In this tutorial, you will learn how to create PostgreSQL stored procedures with INOUT parameters.
plprofiler: PL/pgSQL Profiler Examples
Summary: The plprofiler is an extension for the PostgreSQL database system to create performance profiles of PL/pgSQL functions and stored procedures.
pg_variables: session variables with various types
Summary: The pg_variables module provides functions for working with variables of various types. The created variables are only available in the current user session.
plpgsql_check: PL/pgSQL source code static checker
Summary: The plpgsql_check extension is a linter tool that does source code static analyze for the PostgreSQL PL/pgSQL language, which is a native language for PostgreSQL stored procedures.
PostgreSQL Tutorial: PL/pgSQL SELECT INTO Statement
Summary: in this tutorial, you will learn how to use the PL/pgSQL SELECT INTO statement to select data from the database and assign it to a variable.
PostgreSQL Tutorial: Dollar-Quoted String Constants
Summary: in this tutorial, you will learn how to use the dollar-quoted string constants ($$) in user-defined functions and stored procedures.
PostgreSQL Tutorial: PL/pgSQL Assert Statement
Summary: in this tutorial, you will learn about the PostgreSQL assert statement and how to use it for debugging purposes.
PostgreSQL Tutorial: PL/pgSQL Block Structure
Summary: in this tutorial, you will learn about the block structure of PL/pgSQL and how to write and execute your first PL/pgSQL block.