BIT_OR function [Aggregate]

Takes n bit arrays and returns a bitwise OR-ing of its arguments using the following logic: for each bit compared, if any bit is 1, return 1; otherwise, return 0.

Syntax 
BIT_OR( bit-expression )
Parameters

  • expression   The expression for which the value is to be determined. This is commonly a column name.

See also
Standards and compatibility

  • SQL/2003   Vendor extension.

Example

Suppose you have the following table, t, containing a single column, a, which is a VARBIT data type.

a
0001
0111
0100
0011

You want to know the OR value for the column. You enter the following SELECT statement, which returns 0111:

SELECT BIT_OR( a ) FROM t;

This result is determined as follows:

  1. A bitwise OR is performed between row 1 (0001) and row 2 (0111), resulting in 0111.
  2. A bitwise OR is performed between the result from the previous comparison (0111) and row 3 (0100), resulting in 0111.
  3. A bitwise OR is performed between the result from the previous comparison (0111) and row 4 (0011), resulting in 0111.
Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0