riftehr=> select ascii(substring('sadb', 2,1)); ascii ------- 97 (1 row)
riftehr=> select 24::bit(8); bit ---------- 00011000 (1 row) riftehr=> select ascii(substring('sadb', 2,1))::bit(8); ascii ---------- 01100001 (1 row) Why is the last one headed "ascii" and not "bit"?