Re: [SQL] Summing & Grouping in a Hierarchical Structure

> That said, now that I have finally gotten the chance to try ltree, I think I > like it a lot. Hello Don, Yes, after looking at ltree --which I had not done before-- I have to agree with Misa that it looks like the right solution for your problem. That is not to say that "brute force" SQL

Re: [SQL] Summing & Grouping in a Hierarchical Structure

This works fine: test_ltree=> SELECT path, trans_amt FROM testcat; path | trans_amt -+--- TOP.Transportation.Auto.Fuel| 50.00 TOP.Transportation.Auto.Maintenance | 30.00 TOP.Transportati