2 583
edições
Linha 3: | Linha 3: | ||
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
CREATE VIEW wiki_print1_hbig AS | |||
SELECT len, | SELECT len, | ||
bitstring, | bitstring, | ||
hbig as hbig_dec, | hbig as hbig_dec, | ||
Linha 10: | Linha 10: | ||
hbig>>4 as value_dec, | hbig>>4 as value_dec, | ||
len as len_dec | len as len_dec | ||
FROM ( | FROM ( | ||
SELECT row_number() over() AS count, bitstring, | |||
natcod.vBit_to_hSml( bitstring ) as hbig, | |||
natcod.vBit_to_hSml( bitstring ) as hbig, length(bitstring) as len, | length(bitstring) as len, | ||
natcod.vbit_to_hiddenBig( bitstring ) as hidd, | natcod.vbit_to_hiddenBig( bitstring ) as hidd, | ||
natcod.vbit_to_baseh(bitstring,4,true) as b4h, | natcod.vbit_to_baseh(bitstring,4,true) as b4h, | ||
natcod.vbit_to_baseh(bitstring,16,true) as b16h | natcod.vbit_to_baseh(bitstring,16,true) as b16h | ||
FROM natcod.generate_vbit_series(11) t(bitstring) | FROM natcod.generate_vbit_series(11) t(bitstring) | ||
) | ) t2 | ||
) | ; | ||
CREATE VIEW wiki_print2_hcount AS | |||
SELECT row_number() over() AS count, bitstring, | |||
natcod.vbit_to_baseh(bitstring,16,true) as b16h, | |||
natcod.vBit_to_hCount16c48(bitstring,1::bigint) as hcount1, | |||
natcod.vBit_to_hCount16c48(bitstring,17592186044415::bigint) as hc17592186044415 | |||
FROM natcod.generate_vbit_series(11) t(bitstring) | |||
; | |||
</syntaxhighlight> | </syntaxhighlight> | ||
<pre> | <pre> | ||
wiki_print1_hbig: | |||
len | bitstring | hbig_dec | internal_16bits | value_dec | len_dec | len | bitstring | hbig_dec | internal_16bits | value_dec | len_dec | ||
----+-------------+----------+--------------------+-----------+--------- | |||
1 | 0 | 1 | 0 00000000000 0001 | 0 | 1 | 1 | 0 | 1 | 0 00000000000 0001 | 0 | 1 | ||
2 | 00 | 2 | 0 00000000000 0010 | 0 | 2 | 2 | 00 | 2 | 0 00000000000 0010 | 0 | 2 | ||
Linha 40: | Linha 47: | ||
10 | 0000000001 | 42 | 0 00000000010 1010 | 2 | 10 | 10 | 0000000001 | 42 | 0 00000000010 1010 | 2 | 10 | ||
... | ... | ||
wiki_print2_hcount: | |||
count | bitstring | b16h | hcount1 | hc17592186044415 | |||
------+-------------+------+---------------------+--------------------- | |||
1 | 0 | G | 281474976710657 | 299067162755071 | |||
2 | 00 | H | 562949953421313 | 580542139465727 | |||
3 | 000 | J | 844424930131969 | 862017116176383 | |||
4 | 0000 | 0 | 1125899906842625 | 1143492092887039 | |||
5 | 00000 | 0G | 1407374883553281 | 1424967069597695 | |||
6 | 000000 | 0H | 1688849860263937 | 1706442046308351 | |||
7 | 0000000 | 0J | 1970324836974593 | 1987917023019007 | |||
8 | 00000000 | 00 | 2251799813685249 | 2269391999729663 | |||
9 | 000000000 | 00G | 2533274790395905 | 2550866976440319 | |||
10 | 0000000000 | 00H | 2814749767106561 | 2832341953150975 | |||
11 | 00000000000 | 00J | 3096224743817217 | 3113816929861631 | |||
12 | 00000000001 | 00K | 7599824371187713 | 7617416557232127 | |||
13 | 0000000001 | 00M | 11821949021847553 | 11839541207891967 | |||
... | |||
</pre> | </pre> | ||
=== Exemplo de comprimento 11 === | === Exemplo de comprimento 11 === |
edições