Re: Showing a cumlative total by month

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

Thanks!

I'll post that solution when I find it for posterity.