Updating integer column with null values in postgres June 29, 2023 by Tarik This should be, UPDATE table1 SET column_a = NULL WHERE column_b = 'XXX';