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

Common Functions in PostgreSQL

Introduction
The COALESCE() function
The GREATEST() & LEAST() functions
The NULLIF() function
Summary
15. Summary

Instruction

Nicely done! Now it's time to review what we've learned:

  • The IS NULL operator checks if a column value is NULL.
  • The IS NOT NULL operator checks if a column value is not NULL.
  • COALESCE(x, y, ...) returns the first non-NULL argument or replaces a NULL with the value given in the second argument.
  • The GREATEST() and LEAST() functions return the largest and the smallest value among values in the argument list, respectively.
  • The NULLIF(x, y) function returns NULL if x = y. Otherwise, it returns x.

Are you ready for a short quiz?

Exercise

Click Next exercise to continue.