title: JSONB column does not exist
body: <p>I got this error.</p>
  <blockquote>
  <p>ERROR:  column &quot;name&quot; does not exist LINE 6:</p>
  <pre><code>SELECT JS, location, location-&gt;&gt;Name
  
                                ^ SQL state: 42703 Character: 278
  </code></pre>
  </blockquote>
  <p>from this query</p>
  <pre><code>WITH JsonTable AS
  (
      SELECT 
      '[
          {
              &quot;Id&quot;:1,
              &quot;Name&quot;:&quot;A01&quot;,
              &quot;Address&quot;:&quot;aaa&quot;,
              &quot;SearchVector&quot;:null,
              &quot;ParentLocationId&quot;:null
          },
          {
              &quot;Id&quot;:4,
              &quot;Name&quot;:&quot;B-01&quot;,
              &quot;Address&quot;:&quot;bbb&quot;,
              &quot;SearchVector&quot;:null,
              &quot;ParentLocationId&quot;:null
          }
      ]'::jsonb AS JS
  ) 
  SELECT JS, location, location-&gt;&gt;Name
  FROM JsonTable, jsonb_array_elements(JS) x (location)
  </code></pre>
  <p>How can I select JSON value?</p>