title: Postgresql 9.4 JSONB type, Select by date range
body: <p>I'm migrating from Mongodb, and looking how select by range using jsonb type, I have ~2.880.000 records by day and I need query the database by station and date fields, I know how select by time range</p>
  
  <pre><code>SELECT * FROM stations WHERE date &gt;= '2014-02-01' AND date &lt;  '2014-03-01 AND station = 'AA01'
  </code></pre>
  
  <p>But I don't know how query the database with JSONB data type.</p>
  
  <pre><code>CREATE TABLE stations (
    id SERIAL PRIMARY KEY,
    event JSONB
  );
  
  INSERT INTO test(event) VALUES('{"station":"AA01","value":2.31,"date":"2015-01-23 18:02:48.906569865 +0000 UTC"}');
  INSERT INTO test(event) VALUES('{"station":"AA02","value":4.1,"date":"2015-01-23 19:02:48.906569865 +0000 UTC"}');
  </code></pre>
  
  <p>Also I'm wondering how get a good performance approach, thanks.</p>