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!