Updating integer column with null values in postgres

Question

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"

Got an answer. For integer column, this should be "= null"

no_name
– no_name

2017-10-18 04:43:31 +00:00
Commented Oct 18, 2017 at 4:43 — no_name
– no_name, Commented Oct 18, 2017 at 4:43

Community · Accepted Answer · 2018-07-06 13:06:57Z

176

This should be,

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

edited Jul 6, 2018 at 13:06

CommunityBot

11 silver badge

answered Oct 18, 2017 at 8:11

shiv

2,1301 gold badge19 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Spyros_Spy Over a year ago

can you somehow do that from the table view? Like with mySql Workbench you right click a field and there's a set to null option there. Never mind me you can just delete the value from a field and it will set it to null.

Collectives™ on Stack Overflow

Updating integer column with null values in postgres

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related