Bitwise AND

Result typeinteger type (the widest type of the arguments)

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

Syntax

BIN_AND (number, number [, number ...])

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

See alsoSection 8.6.3, “BIN_OR()”, Section 8.6.6, “BIN_XOR()”, Section 9.7.1, “BIN_AND_AGG()”

Bitwise NOT

Result typeinteger type matching the argument

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

Syntax

BIN_NOT (number)

Returns the result of the bitwise NOT operation on the argument, i.e. one’s complement.

See alsoSection 8.6.3, “BIN_OR()”, Section 8.6.6, “BIN_XOR()” and others in this set.

Bitwise OR

Result typeinteger type (the widest type of the arguments)

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

Syntax

BIN_OR (number, number [, number ...])

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

See alsoSection 8.6.1, “BIN_AND()”, Section 8.6.6, “BIN_XOR()”, Section 9.7.2, “BIN_OR_AGG()”

Bitwise left-shift

Result typeBIGINT or INT128 depending on the first argument

Syntax

BIN_SHL (number, shift)

Returns the first argument bitwise left-shifted by the second argument, i.e. a << b or a·2b.

See alsoSection 8.6.5, “BIN_SHR()”

Bitwise right-shift with sign extension

Result typeBIGINT or INT128 depending on the first argument

Syntax

BIN_SHR (number, shift)

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

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

See alsoSection 8.6.4, “BIN_SHL()”

Bitwise XOR

Result typeinteger type (the widest type of the arguments)

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

Syntax

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

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

See alsoSection 8.6.1, “BIN_AND()”, Section 8.6.3, “BIN_OR()”, Section 9.7.3, “BIN_XOR_AGG()”