title: How to retrieve a data from inside a json postgres
body: <p>In my database table I have a column named <strong>data</strong> and that column's type is jsonb. Here is a sample json of the column.</p>
  
  <pre><code>{"query": {"end-date": "2016-01-31", "start-date": "2016-01-01", "max-results": 1000, "start-index": 1 }}
  </code></pre>
  
  <p>This is the result in a formal format.</p>
  
  <pre><code>{
    "query":{
      "end-date":"2016-01-31",
      "start-date":"2016-01-01",
      "max-results":1000,
      "start-index":1
    }
  }
  </code></pre>
  
  <p>I need to get the data from the 'start date' inside the 'query' element. How get the data from the start date from a pgsql query</p>