Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

BIT_AND Function

Syntax

Copy
BIT_AND ( [DISTINCT | ALL] expression )

Arguments

expression

The target column or expression that the function operates on. This expression must have an INT, INT2, or INT8 data type. The function returns an equivalent INT, INT2, or INT8 data type.

DISTINCT | ALL

With the argument DISTINCT, the function eliminates all duplicate values for the specified expression before calculating the result. With the argument ALL, the function retains all duplicate values. ALL is the default. See DISTINCT Support for Bit-Wise Aggregations.

On this page: