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

Instruction

The last table we are going to work with in this part is named salary.

Exercise

As its name suggests, this table contains attributes related to each employee's salary:

  • salary_id
  • person_id
  • value

Select all data from that table.