title: select from ... - based on a value in JSON format
body: <p>Let's say I have a database table with several common columns such as name, gender, age, ...</p>
  
  <p>Besides I have an additional column using the JSON datatype (available from Postgres 9.2) with arbitrary length and arbitrary fields in JSON:</p>
  
  <pre><code>{"occupation":"football"}
  
  {"occupation":"football", "hair-colour":"black"}
  
  {"hair-style":"curly"}
  </code></pre>
  
  <p>Using new features of Postgres 9.3 I want to return all rows with <em>occupation = football</em> for instance.</p>
  
  <p>Something like this pseudo: <code>select * from table where json_field.occupation = football</code></p>
  
  <p>Is there a way of doing this?</p>