| Subject | Indenting tree-structure results in recursive CTEs |
|---|---|
| Author | Nols Smit |
| Post date | 2011-07-11T09:45:26Z |
Hi,
On page 27 ("Examples of recursive table expressions" of FireBird 2.1 -- What's New), there is an example (indenting the query results depending on the level) but it's not clear to me whether I must use a column in my tree-structure to keep track of the indent level of the record.
Is it possible to pick up the level of a record in a tree-structure in order to indent the query results depending on the level?
Regards,
Nols Smit
[Non-text portions of this message have been removed]
On page 27 ("Examples of recursive table expressions" of FireBird 2.1 -- What's New), there is an example (indenting the query results depending on the level) but it's not clear to me whether I must use a column in my tree-structure to keep track of the indent level of the record.
Is it possible to pick up the level of a record in a tree-structure in order to indent the query results depending on the level?
Regards,
Nols Smit
[Non-text portions of this message have been removed]