BITWISE_SHIFT_RIGHT()

All functions > BITWISE > BITWISE_SHIFT_RIGHT()

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

Signatures

Returns: Shifted bitstring, or NULL if either operand is NULL

BITWISE_SHIFT_RIGHT(expr: 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

Related operators

• Bitwise right shift

Examples

SELECT
    f1 := BITWISE_SHIFT_RIGHT('1001011'::BITSTRING, 3)::VARCHAR -- Shift right by 3
;