Skip to content

Latest commit

 

History

History
42 lines (30 loc) · 916 Bytes

bit_or.md

File metadata and controls

42 lines (30 loc) · 916 Bytes
description
Returns the bitwise OR of non-NULL input values.

BIT_OR

Syntax

BIT_OR(expression int) → int

  • expression: An expression that evaluates to a data type that can be cast as an integer.

Examples

{% code title="BIT_OR example" %}

SELECT BIT_OR(passenger_count)
FROM eth.recent_blocks 
  
-- EXPR$0
-- 255

{% endcode %}

{% code title="BIT_OR example" %}

SELECT total_gas_used, 
  BIT_OR(transaction_count)
FROM eth.recent_blocks 
GROUP BY total_gas_used

-- total_gas_used, EXPR$1
-- 29.0, 7
-- 5.5, 15

{% endcode %}

Usage Notes

If no rows match, returns a value with all bits set to 0. NULL values have no effect on the result unless all results are NULL, which is treated as no match.

\