title: Applying Multiple Window Functions On Same Partition
body: <p>Is it possible to apply multiple window functions to the same partition? (Correct me if I'm not using the right vocabulary)</p>
  
  <p>For example you can do</p>
  
  <pre><code>SELECT name, first_value() over (partition by name order by date) from table1
  </code></pre>
  
  <p>But is there a way to do something like:</p>
  
  <pre><code>SELECT name, (first_value() as f, last_value() as l (partition by name order by date)) from table1
  </code></pre>
  
  <p>Where we are applying two functions onto the same window?</p>
  
  <p>Reference:
  <a href="http://postgresql.ro/docs/8.4/static/tutorial-window.html" rel="noreferrer">http://postgresql.ro/docs/8.4/static/tutorial-window.html</a></p>