title: How to make "case-insensitive" query in Postgresql?
body: <p>Is there any way to write case-insensitive queries in PostgreSQL, E.g. I want that following 3 queries return same result.</p>
  
  <pre><code>SELECT id FROM groups where name='administrator'
  
  SELECT id FROM groups where name='ADMINISTRATOR'
  
  SELECT id FROM groups where name='Administrator'
  </code></pre>