Remove array values in pgSQL

In version 9.3 and above you can do:

update users set flags = array_remove(flags, 'active')

Documentation on the function can be found here.