title: Call a function for each row in select - Postgres
body: <p>I have a function called "getList(date)". This function returns me a items list (with several columns) from the date inputted in the parameter.</p>
  
  <p>If I call:</p>
  
  <pre><code>SELECT * FROM getList('12/31/2014');
  </code></pre>
  
  <p>It works fine. It returns me a list with the date, the item name and the price.</p>
  
  <p>Something like this:</p>
  
  <pre><code>date        item_description    price
  -----------------------------------------------
  12/31/2014      banana          1
  12/31/2014      apple           2.5
  12/31/2014      coconut         3
  </code></pre>
  
  <p>But I have another table with the dates that I want to search for. </p>
  
  <p>So, I want to select all the dates from that table and, for each row returned, I want to call my function "getList" to have a result like this:</p>
  
  <pre><code> date       item_description    price
   -----------------------------------------------
   12/28/2014     banana          0.5
   12/28/2014     apple           1.5
   12/28/2014     coconut         2
   12/31/2014     banana          1
   12/31/2014     apple           2.5
   12/31/2014     coconut         3
  </code></pre>
  
  <p>I don't know exactly how to do it. Of course my data is not a fruit list. This is just to explain the whole thing easier.</p>
  
  <p>Thank you very much.</p>