|
# s should be a bitstring.
|
|
# Right-pad s with 0s so that the length of the output string is a multiple of 8.
|
|
CREATE OR REPLACE FUNCTION print_bits(s) as (
|
|
format('{:0<{}}', s, (ceil(length(s) / 8) * 8)::INT)
|
|
);
|
|
|
|
# Example:
|
|
select print_bits('101'::BITSTRING);
|