title: Query array field for multiple values
body: <p>I have a <code>roles</code> field in a <code>Users</code> table of type <code>Array</code>. I need to be able to get all users that have both role 'admin' and role 'member'. FOr now I use this query:</p>
  
  <p><code>select * from users where 'member' = ANY(roles) and 'admin' = ANY(roles);</code></p>
  
  <p>I was wondering if there was a cleaner way to do this.</p>