shiftrightunsigned function

Returns a bitwise unsigned signed integral number right shifted by n bits.

Syntax

shiftrightunsigned(expr, n)

Arguments

  • expr: An INTEGER or BIGINT expression.

  • n: An INTEGER expression specifying the number of bits to shift.

Returns

The result type matches expr.

When n is negative the result is 0.

Examples

> SELECT shiftrightunsigned(4, 1);
 2
> SELECT shiftrightunsigned(-4, 1);
 2147483646