title: How do I query a PostgreSQL JSON column for a specific type of value?
body: <p>I have a table <code>responses</code> which has a JSON column <code>value</code>. The <code>value</code> column <em>should</em> be an array of text values, like so:</p>
  
  <pre><code>["Value One", "Value Two", "Value Three"]
  </code></pre>
  
  <p>However, a bug in the associated application resulted in some of these values being saved as a string, like:</p>
  
  <pre><code>"Value One"
  </code></pre>
  
  <p>Is there a way to query this column for only text/string types so I can address the bad entries?</p>