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
2. The person table
Syntax of PL/pgSQL
Function parameters
Handling exceptions
Summary

Instruction

Now, let's see what the person table contains.

Exercise

Select all columns from the person table, which stores information about employees who work at the company, as well as a reference to the department each employee works in:

  • person_id
  • department_id
  • first_name
  • last_name
  • start_date
  • gender