PostgreSQL›Aggregate Functions›BIT_AND
←BOOL_OR

BIT_ANDAggregate Functions

BIT_OR→

Returns the bitwise AND aggregate.

Syntax

BIT_AND(expr)

Example

Enter values below to update the example in real time.

flags→
common_flags→
user_permissions→
SELECT BIT_AND(flags) AS common_flags FROM user_permissions;