Right shift

Shifts the bits of the left integer operand right by the number of positions in the right operand.

Category: bitwise

SQL symbol: >>

Syntax

sql

<value> >> <count>

Parameters

<value> — The integer whose bits are shifted. The shift is arithmetic, so the sign is preserved. Accepts integer.
<count> — How many positions to shift by, 0..63. Accepts integer.

Returns

integer

Examples

sql

SELECT 256 >> 4, -1 >> 1;

16 | -1

Signatures

integer >> integer → integer

Notes

Right shift is ARITHMETIC, not logical: the sign bit is copied, so -1 >> 1 is -1 and a negative value never becomes positive by shifting. The shift count must be 0..63 - the operands are 64-bit integers, and a count outside that range fails loud ('bitwise_shr: shift count out of range') rather than wrapping or saturating.