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
6. Invoking the new circumference function
Summary

Instruction

Good job! We've successfully created our first custom function, named get_circumference(diameter).

Before we use this function in our code, let's verify the result it returns.

Exercise

Select the following columns from the circle table:

  • id
  • diameter
  • get_pi() * diameter as cal_circumference
  • get_circumference(diameter) as circumference

Double-check that the columns cal_circumference and circumference have the same (and correct) values.