Updating integer column with null values in postgres

postgresql null sql-update alter
no_name picture no_name · Oct 18, 2017 · Viewed 61.8k times · Source

I would like to update my column with other column in other table. Before doing so, I would like to nullify my column(integer) first. However, below code did not work. (column_a: bigint; column_b: text) 

UPDATE table1
SET column_a IS NULL
WHERE column_b = 'XXX';

ERROR: syntax error at or near "ISNULL"

Answer

shiv picture shiv · Oct 18, 2017

This should be,

UPDATE table1 
SET column_a = NULL
WHERE column_b = 'XXX';

Related questions

Don't update column if update value is null

I have a query like this (in a function): UPDATE some_table SET column_1 = param_1, column_2 = param_2, column_3 = param_3, column_4 = param_4, column_5 = param_5 WHERE id = some_id; Where param_x is a parameter of my function. Is there a way …

Read More
What is the PostgreSQL equivalent for ISNULL()

In MS SQL-Server, I can do: SELECT ISNULL(Field,'Empty') from Table But in PostgreSQL I get a syntax error. How do I emulate the ISNULL() functionality ?

Read More
Best way to check for "empty or null value"

What is best way to check if value is null or empty string in Postgres sql statements? Value can be long expression so it is preferable that it is written only once in check. Currently I'm using: coalesce( trim(stringexpression),…

Read More