Conditional update in PostgreSQL (updated!)
What should you do if you only want your column to be updated if the supplied value is valid?
Let’s say we are updating a user’s profile. There are many different fields:, name, email address, phone number, etc. But the user is…