Ir para o conteúdo

Código Natural/Listagens com representações: mudanças entre as edições

m
sql simplify
Sem resumo de edição
m (sql simplify)
Linha 6: Linha 6:
<syntaxhighlight lang="sql">
<syntaxhighlight lang="sql">
SELECT row_number() over() AS count, bitstring,
SELECT row_number() over() AS count, bitstring,
      -- x as hbig,
       natcod.vBit_to_hSml( bitstring ) as hbig,
       natcod.vBit_to_hSml( bitstring ) as hbig,
       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 (
FROM natcod.generate_vbit_series(8) t(bitstring);
  SELECT bitstring, natcod.vbit_to_hbig(bitstring) x
  FROM natcod.generate_vbit_series(8) t(bitstring)
) t2;
</syntaxhighlight>
</syntaxhighlight>


2 583

edições