PostgreSQL UPDATE all rows in an array to something while updating all rows NOT in array to something else

Question

I have a query that seems to work:

UPDATE questions SET active=TRUE WHERE id=ANY ([1, 5, 7]);

But I also want to set all other rows to active=FALSE

Essentially, I want to do the equivalent of running these two lines

UPDATE questions SET active=FALSE;
UPDATE questions SET active=TRUE WHERE id=ANY ([1, 5, 7]);

But I would like to accomplish this in a single query if possible. Is there a way to do this?

klin · Accepted Answer · 2017-06-28 21:40:17Z

2

Use the condition as a Boolean value to set:

UPDATE questions SET active = (id = ANY(array[1, 5, 7]));

answered Jun 28, 2017 at 21:40

klin

123k15 gold badges240 silver badges262 bronze badges

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

1 Answer 1