Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Writing User-Defined Functions in PostgreSQL

Introduction
1. Introduction
Syntax of PL/pgSQL
Function parameters
Handling exceptions
Summary

Instruction

Welcome! In this part of our course, we'll explain the basics of creating functions in Postgres.

We will cover the basics of PL/pgSQL syntax (variables, constants, assignments, loops, exceptions, etc.), function parameters, and function overloading.

Before we dig into the details, let's review the database tables we are going to work with. We'll be working with a small company's database. Our database tables store data related to departments, employees, and salaries.

The first table we are going to review is named department.

Exercise

Select all columns from the department table, which contains just the following two attributes related to a department object:

  • department_id
  • name