On Fri, Sep 11, 2015 at 10:15 AM, David G. Johnston <
david.g.johnston@gmail.com> wrote:
>
> On Fri, Sep 11, 2015 at 10:46 AM, David Nelson <
dnelson77808@gmail.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.
