title: postgres pull out multiple values in a JSON array
body: <p>I have a table where one of the columns is a JSON array. for each key there are multiple values.</p>
  
  <p>So I use this query to select out the JSON</p>
  
  <pre><code>select  x.cola eventid, x.colb
  from special_event_conflicts t
  cross join lateral json_each(t.eventid) as x(cola, colb)
  </code></pre>
  
  <p>which produces</p>
  
  <pre><code>"525947";"{"f1":133,"f2":2428,"f3":"MULTILINESTRING((1013339.30779158 180228.160778359,1013395.51179424 180119.844273224))"}"
  </code></pre>
  
  <p>what I want is to be able to select out the f1,f2,f3 values into there own columns </p>