2 583
edições
Linha 20: | Linha 20: | ||
) t2 | ) t2 | ||
; | ; | ||
-- drop VIEW wiki_print2_hcount; | |||
CREATE VIEW wiki_print2_hcount AS | CREATE VIEW wiki_print2_hcount AS | ||
SELECT row_number() over() AS count, bitstring, | SELECT row_number() over() AS count, bitstring, | ||
Linha 36: | Linha 36: | ||
FROM wiki_print2_hcount | FROM wiki_print2_hcount | ||
) t; | ) t; | ||
CREATE VIEW wiki_print4_hcount_human AS | |||
select *, natcod.hCount16c48_asBeauty(hc,4,true) as hc_human | |||
from ( | |||
select h_path, c, natcod.vBit_to_hCount16c48(h_path,c::bigint) as hc | |||
from ( SELECT bitstring as h_path, | |||
unnest( array[ random_between(1,3509999999)::bigint, 123::bigint, random_between(1,550999999)::bigint ] ) as c | |||
FROM wiki_print2_hcount | |||
) tt | |||
) tt2 order by 3 | |||
; | |||
</syntaxhighlight> | </syntaxhighlight> | ||
edições