Re: hierarchical query problem

Hexathioorthooxalate wrote:

> (the '-' are your formatting to show the hierarchy in
> the NNTP post, not real padding in the column ID?)

Yes. Sorry for not having stated that clearly.

> how do we know which data
> are the root rows and therefore what to use in the average date calculation?

I can easily determine root rows because they have PRIOR ID = NULL.

> If you provided a flag like Y or N or 0 or 1 to say this column is a root,
> use it to calculate the average date of all data up to the row with the next
> Y or 1, then (for me anyway) the problem is significantly reduced to just
> getting the syntax of the appropriate Oracle ANALYTIC FUNCTION right.

Thanks for the hint.

> Fire through some feedback and I'll see if I can help. Also, same database
> as before (9i not 10g?)

9.0.1. I beg your pardon once again.

Thank for your help. Kind regards,

-- 
Cris Carampa (cris119_at_operamail.com)

- We're gonna be like three little Fonzies here. And what's Fonzie like?
- Cool?