Re: Cascading sum in tree with CTE?

From: silly sad <sad(at)bankir(dot)ru>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Cascading sum in tree with CTE?
Date: 2010-04-09 09:12:56
Message-ID: 4BBEEF98.301@bankir.ru
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

to select a whole subtree of a particular node of a tree.
u have to modify the tree representation in one of the two ways
(according to you fine-tuned needs)

(1) store in the EACH node the PATH from root to this node
(2) store (l,r) segment representing the INCLUSIONS of nodes into other
nodes subtree (exactly as segments include each other)

(2) i forgot the "official" name of this type of tree representation.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Harald Fuchs 2010-04-09 10:51:58 Re: Cascading sum in tree with CTE?
Previous Message Svenne Krap 2010-04-09 07:17:49 Cascading sum in tree with CTE?