Re: running aggregates entirely in SQL?

Josh Berkus wrote:
> I have. I find it really, really fast for "in branch" queries (which other
> trees suck at) but really, really slow to update. So it's a good model for
> a tree which will be modified, say, once every 10,000 reads.

Same here. I've used it in a Sybase/MSSQL environment with Transact-SQL
stored procedures but my postgres kung-fu is nowhere near adequate to
replicate that functionality. I have used it for a message board system
that allowed deep threading successfully. I think it would also be good
for large organizational charts or family tree type models but I don't
have any of those really in my current project (motorsport event
management software).

Cheers,

Brian