BIN_SHR()

Bitwise right-shift with sign extension

Result type

BIGINT or INT128 depending on the first argument

Syntax

BIN_SHR (number, shift)

Table 1. `BIN_SHR` Function Parameters
Parameter	Description
number	A number of an integer type
shift	The number of bits the number value is shifted by

Returns the first argument bitwise right-shifted by the second argument, i.e. a >> b or a/2^b.

The operation performed is an arithmetic right shift (x86 SAR), meaning that the sign of the first operand is always preserved.

Bitwise XOR

Result type

integer type (the widest type of the arguments)

Note	`SMALLINT` result is returned only if all the arguments are explicit `SMALLINT`s or `NUMERIC(n, 0)` with n <= 4;otherwise small integers return an `INTEGER` result.

Syntax

BIN_XOR (number, number [, number ...])

Table 1. `BIN_XOR` Function Parameters
Parameter	Description
number	A number of an integer type

Returns the result of the bitwise XOR operation on the argument(s).