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
7. Updating the circle table – circumference
Summary

Instruction

Awesome! We have successfully tested the get_circumference(diameter) function and know that it returns the correct circumference values.

Now, let's use this function and update the circumference value for all records in the circle table.

Exercise

Write an UPDATE statement that updates all records of the circle table and sets circumference to be the result of the function call get_circumference(diameter). Be sure to pass in the correct column to this function.

Stuck? Here's a hint!

Here's the correct answer:

UPDATE circle
SET circumference = get_circumference(diameter)