title: PostgreSQL how to use bitwise operator |=
body: <p>I want to execute the following update query at PostgreSQL db but it does not work and gives syntax error.</p>
  
  <p>Query as follows</p>
  
  <pre><code>update wl_user set role_bitmask= role_bitmask|=1 where email='faisal@gmail.com'
  </code></pre>
  
  <p>Problem seems to be with <code>|=</code> operator, does anybody have idea how to use |= operator in PostgreSQL?</p>
  
  <p>Following is the error.</p>
  
  <blockquote>
  <pre><code>[Err] ERROR:  operator does not exist: integer |= integer
  LINE 1: ...pdate wl_user set role_bitmask=role_bitmask|=1 where ...
                                                               ^
  HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
  </code></pre>
  </blockquote>