| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Fetter | 2004-05-11 18:43:36 | Re: running aggregates entirely in SQL? |
| Previous Message | elein | 2004-05-11 17:27:10 | Re: running aggregates entirely in SQL? |