> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

> Reference material for BIT_OR

# BIT_OR

Performs a bitwise `OR` operation on an integer expression, ignoring null input values. Bitwise `OR` compares two bits and returns `1` if either is `1`, and `0` otherwise.

Numbers are represented in two's complement, a binary method for signed integers, as follows:

* Positive numbers are represented in standard binary form, while negative numbers are derived by inverting the bits of their positive counterpart and adding `1`.
* A leftmost bit of `0` indicates a positive number, while `1` indicates a negative number.

## Syntax

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
BIT_OR([ DISTINCT ] <expression>) [FILTER ([WHERE] <condition>)]
```

Note: `DISTINCT` has no effect on the function's result.

## Parameters

| Parameter      | Description                                                       | Supported input types |
| :------------- | :---------------------------------------------------------------- | :-------------------- |
| `<expression>` | The expression used to compute the result.                        | `INT`, `BIGINT`       |
| `<condition>`  | An optional boolean expression to filter rows used in aggregation | `BOOL`                |

## Return Types

The `BIT_OR` function returns a result of either type `INT` or `BIGINT`, depending on the type of the input.

## Examples

**Example**

The following code example performs a bitwise `OR` operation across a series of integers ranging from `1` to `3`:

<div className="query-window">
  ```
  SELECT BIT_OR(a)
  FROM GENERATE_SERIES(1, 3) as a;
  ```

  | bit\_or <span>int null</span> |
  | :---------------------------- |
  | 3                             |

  <p><span>Rows: 1</span><span>Execution time: 9.15ms</span></p>
</div>

In a 4-bit system, the binary representation of integers from `1` to `3` is:

* `1` `->` `0001`
* `2` `->` `0010`
* `3` `->` `0011`

The bitwise `OR` of `0001` and `0010` is `0011`, which equals `3`. The bitwise `OR` between `0011` and itself is `0011`, or `3`.

**Example**

The following code example performs a bitwise `OR` operation across a series of integers ranging from `-1` to `1`:

<div className="query-window">
  ```
  SELECT BIT_OR(a)
  FROM generate_series(-1, 1) as a;
  ```

  | bit\_or <span>int null</span> |
  | :---------------------------- |
  | -1                            |

  <p><span>Rows: 1</span><span>Execution time: 5.59ms</span></p>
</div>

In a 4-bit system, the binary representation of integers from `-1` to `1` is:

* `-1` `->` `1111`
* `0` `->` `0000`
* `1` `->` `0001`

The bitwise `OR` of `1111` and any integer is `1111`, or `-1`.