How to upsert non-null columns (PostgreSQL)

Wappler General How To
#1 
INSERT INTO user (id, name, randomStuff) VALUES (:P1, :P2, :P3) 
ON CONFLICT (id) 
DO 
UPDATE SET name=:P2, randomStuff=:P3; -- How can I skip updating :P3 here if it's NULL?

I assume this always updates “randomStuff”, even if :P3 is NULL. How can I skip updating this column (randomStuff) if :P3 is NULL? I don’t want to overwrite something non-null with null.

Thanks for any advice!

#2

Solved:

INSERT INTO user t(id, name, randomStuff) VALUES (:P1, :P2, :P3) 
ON CONFLICT (id) 
DO 
UPDATE SET name=:P2, randomStuff=coalesce(:P3, t.randomStuff);

coalesce returns the first non-null argument