meta data for this page
  •  

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.