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 - 05:58:29 CST
