Re: Fetching from a hierarchical data structure?

Maury Markowitz wrote:
> "Jan Hidders" <hidders_at_REMOVE.THIS.win.tue.nl> wrote in message
> news:9aljiq$g37$2_at_news.tue.nl...
> > I assume you have a good reason why you compute the identifiers
> > first and then generate a query that explicitly mentions them
> > instead of simply computing them directly in the SQL query itself.
>
> Yes, I don't know how. I guess this is what I'm really asking for,
> how to do this in the SQL side of things. The data structure is a
> pure tree, with each row listing a (option) pointer back to it's
> parent.

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?

-- 
  Jan Hidders