title: Case Insensitive search with POstgres Similar To
body: <p>I have such query in my Django code</p>
  <pre><code>cond = self.text_query(field.id, f'''
                                          EXISTS(
                                              SELECT *
                                              FROM {self.fieldvalue_db_view}
                                              WHERE entry_id = {self.db_table}.id AND
                                                                      {self.fieldvalue_db_view}.field_id = {field.id} AND
                                                                      {self.fieldvalue_db_view}.{text_search_column} SIMILAR TO %(pattern)s
                                          )
                                      ''', dict(pattern='%' + val + '%'))
  </code></pre>
  <p>When</p>
  <pre><code>val = '%%john smith%%' or val = '%%john%smith%%'
  </code></pre>
  <p>it did not return a result like 'John smith', but if</p>
  <pre><code>val = '%%john%smith%|%smith%john%%'
  </code></pre>
  <p>it returns results with 'John smith'.</p>
  <p>How this case sensitiveness can be solved?</p>
  <p>Thanks,</p>