title: Convert String to Array - PostgreSQL
body: <p>I have a column in a table that stores names separated by commas, example: "Mel's Hou Rest, Mel's Lad Rest". What I need is to convert this string into an array separated by commas.</p>
  
  <p>The query I need is:</p>
  
  <pre><code>SELECT home_location, subs_state FROM cust
  WHERE (home_location = ANY('{"Mel''s Hou Rest", Mel''s Lad Rest"}')) AND subs_state = 'active'
  </code></pre>
  
  <p>I have tried this, but I keep getting an error:</p>
  
  <pre><code>WHERE (home_location = ANY(string_to_array("Mel's Hou Rest, Mel's Lad Rest", ',')::text[])
  </code></pre>
  
  <p>Is there any way to accomplish this without me having to change the database from 'text' to 'array'</p>