Re: Fetching from a hierarchical data structure?

Maury Markowitz wrote:
> "Jan Hidders" <hidders_at_REMOVE.THIS.win.tue.nl> wrote in message
> news:9at1l6$j44$1_at_news.tue.nl...
> > If there is a maximum height of the tree then it can be done in plain
> > SQL without special extensions such as in Oracle. Is there?
>
> No. In fact one of our customers flattened it out to one level, and
> another had 10 deep!

Hm. Is this depth fixed per customer? If this depth is stored somewhere you can generate an SQL query that computes the tree for that depth.

-- 
  Jan Hidders