<div dir="ltr">On Fri, Sep 11, 2015 at 10:15 AM, David G. Johnston <<a
href="mailto:david.g.johnston@gmail.com">david.g.johnston@gmail.com</a>>wrote:<br />><br />> On Fri, Sep 11,
2015at 10:46 AM, David Nelson <<a href="mailto:dnelson77808@gmail.com">dnelson77808@gmail.com</a>> wrote:<br
/>>><br/>>> I would like to add a running total column to the view, but can't quite get there. I figured
outhow to show the information I want using a CTE, but I can not figure out how to translate that to a single query to
definea view with. So I'm hoping someone can point me in the right direction.<br />>><br />><br />> -->
<a
href="http://www.postgresql.org/docs/9.3/interactive/functions-window.html">http://www.postgresql.org/docs/9.3/interactive/functions-window.html</a><br
/>><br/>> David J.<br />> <br />Ha! How ironic. I made myself a note to try to understand windowing
functions<br/>a couple of weeks ago due to a conversation on one of the PostgreSQL lists<br />regarding finding first
andlast values. Looks like that just got moved up<br />in priority.<br /><br />Thanks!<br /><br />I'll post that
solutionwhen I find it for posterity.<br /></div>
