PostgreSQL Tutorial: PL/pgSQL Function Returns A Table
Summary: in this tutorial, you will learn how to develop PostgreSQL functions that return a table.
PostgreSQL Tutorial: PL/pgSQL IF Statement
Summary: in this tutorial, you will learn how to use the PL/pgSQL if statements to execute a command based on a specific condition.
PostgreSQL Tutorial: PL/pgSQL Loop Statements
Summary: in this tutorial, you will learn about the PL/pgSQL loop statement that executes a block of code repeatedly.
PostgreSQL Tutorial: PL/pgSQL Record Types
Summary: in this tutorial, you will learn about the PL/pgSQL record types that allow you to define variables that can hold a single row from a result set.
PostgreSQL Tutorial: PL/pgSQL Row Types
Summary: in this tutorial, you will learn how to use the PL/pgSQL row types to declare row variables that hold a complete row of a result set.
PostgreSQL Tutorial: PL/pgSQL Variables
Summary: in this tutorial, you will learn various techniques to declare PL/pgSQL variables.
PostgreSQL Tutorial: PL/pgSQL While Loop
Summary: in this tutorial, you will learn about the PL/pgSQL while loop statement.
PostgreSQL Tutorial: ALTER TRIGGER
Summary: In this tutorial, you will learn how to use the PostgreSQL ALTER TRIGGER statement to rename a trigger.
PostgreSQL Tutorial: CREATE TRIGGER
Summary: In this tutorial, you will learn how to use the PostgreSQL CREATE TRIGGER statement to create a trigger.
PostgreSQL Tutorial: Disable Triggers
Summary: In this tutorial, you will learn how to disable triggers by using the ALTER TABLE DISABLE TRIGGER statement.