Skip site navigation (1) Skip section navigation (2)

Re: running aggregates entirely in SQL?

From: Brian Ghidinelli <brian(at)pukkasoft(dot)com>
To: sfpug(at)postgresql(dot)org
Subject: Re: running aggregates entirely in SQL?
Date: 2004-05-11 18:01:13
Message-ID: 40A114E9.9040502@pukkasoft.com (view raw or flat)
Thread:
Lists: sfpug
Joe Celko has some examples in his "SQL for Smarties" book for doing 
running aggregates entirely in SQL.  I believe they will work in most 
database servers.  I don't have the book handy but it's a place to look.

On the Celko note - has anyone implemented his nested tree model?  It's 
really great for arbitrarily deeply nested hierarchies.


Brian


> On Tue, May 11, 2004 at 01:10:58PM -0400, Aditya wrote:
> 
>>I could have sworn that I saw an email from Josh Berkus on sfpug about how to
>>do running aggregates (ie. a running tally or total, say in an invoice)
>>entirely in PostgreSQL, however googling only finds:
>>
>>  http://archives.postgresql.org/pgsql-novice/2003-09/msg00305.php
>>
>>and I can't find it in the sfpug archives:
>>
>>  http://archives.postgresql.org/sfpug/
>>
>>am I mistaken?
>>
>>If so, is there a way to keep a running tally entirely in PostgreSQL?



In response to

Responses

sfpug by date

Next:From: David FetterDate: 2004-05-11 18:43:36
Subject: Re: running aggregates entirely in SQL?
Previous:From: eleinDate: 2004-05-11 17:27:10
Subject: Re: running aggregates entirely in SQL?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group