Re: More pain and sufferring with Tropashko's materialized path...
From: Mark Johnson <102334.12_at_compuserve.com>
Date: Wed, 12 Nov 2003 03:58:29 -0800
Message-ID: <o084rvclb8cj7qni50a4ukiikqsjfrm9kc_at_4ax.com>
Date: Wed, 12 Nov 2003 03:58:29 -0800
Message-ID: <o084rvclb8cj7qni50a4ukiikqsjfrm9kc_at_4ax.com>
Vadim Tropashko <vadimtro_at_yho.cm> wrote:
>Mikito Harakiri wrote:
>> "Vadim Tropashko" <vadimtro_at_yho.cm> wrote in message
>> news:HGasb.25$Up4.55_at_news.oracle.com...
>>
>>>
>>>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.
>
>That's right, there seem to be no simple identity involving level:-(
>Here is, however, another nice identity
>
>N = NUMER - (DENOM+1)/4
N = Denom - (Numer+1)/4
Received on Wed Nov 12 2003 - 12:58:29 CET