title: Rails 4 Querying a hstore array?
body: <p>I have a answers hstore array column in the reviews table in a postgres 9.3.2 Database on rails 4.1.4</p>
  
  <pre><code>add_column :reviews, :answers, :hstore, array:true
  </code></pre>
  
  <p>with values like that:</p>
  
  <pre><code>=&gt; [{"qid"=&gt;"299", "val"=&gt;"1", "field_type"=&gt;"rating_field"}, {"qid"=&gt;"300", "val"=&gt;"2", "field_type"=&gt;"rating_field"}]
  </code></pre>
  
  <p>I'm trying to get all values from qid == 299, so the output should be <code>1</code>, or an array when there are multiple values</p>
  
  <p>I tried: <code>Review.where("answers -&gt; 'qid' = '299'")["val"]</code></p>
  
  <p>Some ideas?</p>
  
  <p>Thanks, Patrick</p>