title: Postgres casting an array of dates calculated by current_date - array of integers
body: <p>Is it possible to query a field, an array of integers, and return an array of Dates based off the current_date - an int value.</p>
  
  <p>My data structure is something like</p>
  
  <pre><code>_Category_
  name:string
  send_reminders:array[integer]
  
  _Appointment_
  category_id:integer
  title:string
  event_date:date
  
  _Customer_
  appointemtn_id:integer
  name:string
  contact:boolean
  </code></pre>
  
  <p>I want to query the customers who have an appointment reminder on that date. I thought I could accomplish this by </p>
  
  <ol>
  <li>Use Category:send_reminders to generate an array of Dates ([1,2,3] produces [yesterday, the day before, two days before])</li>
  <li>Then use a condition where Appointment date is in that array.</li>
  <li>Select the Customers in that Appointment where contact is true.</li>
  </ol>