title: How to select a row from any hstore values?
body: <p>I've a table <code>Content</code> in a PostgreSQL (9.5) database, which contains the column <code>title</code>. The <code>title</code> column is a <code>hstore</code>. It's a <code>hstore</code>, because the <code>title</code> is translated to different languages. For example:</p>
  
  <pre><code>example=# SELECT * FROM contents;
   id |                    title                    |                    content                     |         created_at         |         updated_at         
  ----+---------------------------------------------+------------------------------------------------+----------------------------+----------------------------
    1 | "de"=&gt;"Beispielseite", "en"=&gt;"Example page" | "de"=&gt;"Beispielinhalt", "en"=&gt;"Example conten" | 2016-07-17 09:20:23.159248 | 2016-07-17 09:20:23.159248
      (1 row)
  </code></pre>
  
  <p>My question is, how can I select the <code>content</code> which <code>title</code> contains <code>Example page</code>?</p>
  
  <pre><code>SELECT * FROM contents WHERE title = 'Example page';
  </code></pre>
  
  <p>This query unfortunately doesn't work. </p>
  
  <pre><code>example=# SELECT * FROM contents WHERE title = 'Example page';
  ERROR:  Syntax error near 'p' at position 8
  LINE 1: SELECT * FROM contents WHERE title = 'Example page';
  </code></pre>