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: NULLIF
Summary: this tutorial shows you how to use PostgreSQL NULLIF function to handle null values. We will show you some examples of using the NULLIF function.
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.
PostgreSQL Tutorial: PL/pgSQL CASE Statement
Summary: in this tutorial, you will learn about the PL/pgSQL case that executes statements based on a certain condition.
PostgreSQL Tutorial: PL/pgSQL Constants
Summary: in this tutorial, you will learn about PL/pgSQL constants whose values cannot be changed.
PostgreSQL Tutorial: PL/pgSQL Continue Statement
Summary: in this tutorial, you will learn how to use the PL/pgSQL continue statement to control the loop.
PostgreSQL Tutorial: PL/pgSQL Create Function
Summary: in this tutorial, you will learn how to use the PostgreSQL CREATE FUNCTION statement to develop user-defined functions.
PostgreSQL Tutorial: PL/pgSQL CREATE PROCEDURE
Summary: in this tutorial, you will learn how to use the PostgreSQL CREATE PROCEDURE statement to create new stored procedures.
PostgreSQL Tutorial: PL/pgSQL Cursor
Summary: in this tutorial, you will learn about the PL/pgSQL Cursors and how to use them to process a result set, row by row.