On Tue, May 11, 2004 at 11:01:13AM -0700, Brian Ghidinelli wrote:
>
> 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.
It's handy :)
BTW, one way I've done it is to create a temporary sequence, then use
it to impose an ordered row structure.
> On the Celko note - has anyone implemented his nested tree model?
> It's really great for arbitrarily deeply nested hierarchies.
See contrib/ltree.
Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!