From: Don Parris [mailto:parri...@gmail.com]
Sent: Tuesday, February 26, 2013 4:55 PM
To: pgsql-sql@postgresql.org
Subject: Re: Using Ltree For Hierarchical Structures
...
I am unaware of the connect_by module, so will have to look into it.
...
Cheers!
Don
For that look into tablefunc Extensi
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
&
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-i
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
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
Hi all,
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-postgresql/
Frankly, if you work wit
