title: How to store array or multiple values in one column
body: <p>Running Postgres 7.4 (Yeah we are in the midst of upgrading)</p>
  
  <p>I need to store from 1 to 100 selected items into one field in a database. 98% of the time it's just going to be 1 item entered, and 2% of the time (if that) there will be multiple items.</p>
  
  <p>The items are nothing more than a text description, (as of now) nothing more than 30 characters long.  They are static values the user selects.</p>
  
  <p>Wanted to know the optimal column data type used to store the desired data. I was thinking BLOB but didn't know if this is a overkill. Maybe JSON?</p>
  
  <p>Also I did think of ENUM but as of now I can't really do this since we are running Postgres 7.4</p>
  
  <p>I also wanted to be able to easily identify the item(s) entered so no mappings or referencing tables.</p>