BIN_SHR()

Available in: DSQL, PSQL

Added in: 2.1

Description

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

Result type: BIGINT

Syntax

BIN_SHR (number, shift)

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