title: Is it possible to pass in a variable amount of parameters to a stored procedure in redshift?
body: <p>I am trying to write a stored procedure in AWS Redshift SQL and one of my parameters needs the possibility to have an integer list (will be using 'IN(0,100,200,...)' inside there WHERE clause). How would I write the input parameter in the header of the procedure so that this is possible (if at all?)</p>
  
  <p>I've tried passing them in as a VARCHAR "integer list" type thing but wasn't sure then how to parse that back into ints.</p>
  
  <p>Update: I found a way to parse the string and loop through it using the SPLIT_PART function and store all of those into a table. Then just use a SELECT * FROM table with the IN() call</p>