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

Function management
7. DROP FUNCTION IF EXISTS

Instruction

Great! Attempting to DROP a function that does not exist will cause an error, so it's highly recommended that you use the DROP command along with the IF EXISTS option.

DROP FUNCTION IF EXISTS circle_area(decimal);

After the DROP FUNCTION IF EXISTS command, you have to specify the name, as well as the types of arguments, of the function that you would like to remove.

Exercise

Drop the get_circle_area(integer) function, but only do so if it exists.