BIT_SHIFT_RIGHT

All functions > BITWISE > BIT_SHIFT_RIGHT

Returns the bitstring shifted right by N positions, filling with zeros on the left.

Signatures

Returns: Bitstring shifted right by N positions

BIT_SHIFT_RIGHT(bitstring: BITSTRING, n: BIGINT) → BITSTRING

Notes

• Bits shifted beyond the right end are discarded
• New bits on the left are filled with zeros
• The length of the result is the same as the input
• Returns NULL if either input is NULL

Examples

SELECT
    f1 := BIT_SHIFT_RIGHT('1001011'::BITSTRING, 3)::VARCHAR,  -- Shift right by 3
    f2 := BIT_SHIFT_RIGHT('1000'::BITSTRING, 2)::VARCHAR,  -- Shift right by 2
    f3 := BIT_SHIFT_RIGHT('0001'::BITSTRING, 1)::VARCHAR,  -- Low bit shifted out
    f4 := ('1000'::BITSTRING >> 2)::VARCHAR  -- Operator syntax: >> for shift right
;