BIN_OR()

Bitwise OR

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_OR (number, number [, number ...])

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

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

Bitwise left-shift

Result type

BIGINT or INT128 depending on the first argument

Syntax

BIN_SHL (number, shift)

Table 1. `BIN_SHL` 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 left-shifted by the second argument, i.e. a << b or a·2^b.