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

"Vadim Tropashko" <vadimtro_at_yho.cm> wrote in message news:Dp9sb.20$Up4.46_at_news.oracle.com...
> The idea is the same as in
>

http://www.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=Fs58b.22%24927 .175%40news.oracle.com

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! Received on Tue Nov 11 2003 - 19:56:26 CET