Re: More pain and sufferring with Tropashko's materialized path...

"Vadim Tropashko" <vadimtro_at_yho.cm> wrote in message news:HGasb.25$Up4.55_at_news.oracle.com...
> Mikito Harakiri wrote:
> > I just noticed a curious identity:
> >
> > SUBSTR(LPAD('', SUBSTR(PATH,1,1 NUMER DENOM
> > --------------- --------------- ---------- ----------
> > KING .1 3 2
> > CLARK .1.3 19 16
> > MILLER .1.3.1 39 32
> > BLAKE .1.3.1.1 79 64
> > TUR .1.3.1.1.4 1251 1024
> > MAR .1.3.1.1.3 627 512
> > WAR .1.3.1.1.2 315 256
> > ALL .1.3.1.1.1 159 128
> > JONES .1.1 7 4
> > FORD .1.1.2 27 16
> > SMITH .1.1.2.1 55 32
> > SCOTT .1.1.1 15 8
> > ADAMS .1.1.1.1 31 16
> >
> > Sum of the numbers in the materialized path is the power of DENOM!
>
> And NUMER = DENOM + 2^LEVEL - 1.

SQL> select log(2, path_numer('1.2.4')- path_denom('1.2.4')+1) from dual

Wrong:

LOG(2,PATH_NUMER('1.2.4')-PATH_DENOM('1.2.4')+1)

                                        5.169925

which was expected to be 3. Received on Tue Nov 11 2003 - 20:33:45 CET