2013/2/26 Thomas Kellerer
> Don Parris wrote on 24.02.2013 23:20:
>
> With many thanks to Misa and others who helped out with my question
>> about working with hierarchical data, I have now written a blog post
>> on how I implemented the ltree module to solve my problem.
>>
>> http://dcparris.ne
On Tue, Feb 26, 2013 at 2:30 PM, Igor Neyman wrote:
>
>
> From: Don Parris [mailto:parri...@gmail.com]
> Sent: Tuesday, February 26, 2013 1:23 PM
> To: Misa Simic
> Cc: Igor Neyman; pgsql-sql@postgresql.org
> Subject: Re: [SQL] Using Ltree For Hierarchical Structures
>
> Hi Igor,
> As Misa points
From: Don Parris [mailto:parri...@gmail.com]
Sent: Tuesday, February 26, 2013 1:23 PM
To: Misa Simic
Cc: Igor Neyman; pgsql-sql@postgresql.org
Subject: Re: [SQL] Using Ltree For Hierarchical Structures
Hi Igor,
As Misa points out, my original design used 2 tables - category & line-items.
Eit
Don Parris wrote on 24.02.2013 23:20:
With many thanks to Misa and others who helped out with my question
about working with hierarchical data, I have now written a blog post
on how I implemented the ltree module to solve my problem.
http://dcparris.net/2013/02/24/using-ltree-hierarchical-postgr
Hi Igor,
As Misa points out, my original design used 2 tables - category &
line-items. Either way it's two tables.The biggest difference lies in
the approach to summing line-items by various levels of category - with
each branch of the tree having different levels.
I cannot speak to performa
Adrian:
Thanks for the prompt reply. I was able to create a new DB by renaming
Default to another name. This was a carry over from our project which was
previously using SQLExpress.
Thanks again for the reply.
Regards,
Murali
--
View this message in context:
http://postgresql.1045698.n5.
Hi Igor,
I agree it is all "in the eyes of beholder".
Would be good if you can show how to achieve the goal (Summing on Top
Levels categories in hierarchy) with CTE?
For example show all categories in level 2 (x), and sum amounts for each...
(Sum takes all amounts from all transactions of its ch
From: Don Parris [mailto:parri...@gmail.com]
Sent: Sunday, February 24, 2013 5:21 PM
To: pgsql-sql@postgresql.org
Subject: Using Ltree For Hierarchical Structures
Hi all,
With many thanks to Misa and others who helped out with my question about
working with hierarchical data, I have now writte