This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.
BIT_SET
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
The BIT_SET() function sets the bit value at a given position to a new value:
SELECT bit_set(3, 0), bit_set(3, 2), bit_set(3, 0, 0), bit_set(3, 2, 1);
create.select( bitSet(inline(3), 0), bitSet(inline(3), 2), bitSet(inline(3), 0, 0), bitSet(inline(3), 2, 1)).fetch();
The result being
+---------+---------+---------+---------+ | bit_set | bit_set | bit_set | bit_set | +---------+---------+---------+---------+ | 3 | 7 | 2 | 7 | +---------+---------+---------+---------+
Dialect support
This example using jOOQ:
bitSet(inline(3), 2)
Translates to the following dialect specific expressions:
-- ASE, SQLDATAWAREHOUSE, SYBASE (3 | (1 * CAST(power(2, 2) AS int))) -- AURORA_MYSQL, AURORA_POSTGRES, BIGQUERY, COCKROACHDB, DUCKDB, MARIADB, MEMSQL, MYSQL, POSTGRES, REDSHIFT, SQLITE, -- VERTICA, YUGABYTEDB (3 | (1 << 2)) -- DB2, INFORMIX bitor( 3, (1 * CAST(power(2, 2) AS integer)) ) -- EXASOL bit_set(3, 2) -- FIREBIRD bin_or( 3, bin_shl(1, 2) ) -- H2 bitor( 3, lshift(1, 2) ) -- HSQLDB bitor( 3, (1 * CAST(power(2, 2) AS int)) ) -- ORACLE ((3 + (1 * CAST(power(2, 2) AS number(10)))) - bitand( 3, (1 * CAST(power(2, 2) AS number(10))) )) -- SNOWFLAKE bitor( 3, bitshiftleft(1, 2) ) -- SQLSERVER set_bit(3, 2) -- TERADATA setbit(3, 2) -- TRINO bitwise_or( 3, bitwise_left_shift(1, 2) ) -- ACCESS, DERBY, HANA /* UNSUPPORTED */
(These are currently generated with jOOQ 3.19, see #10141), or translate your own on our website
Feedback
Do you have any feedback about this page? We'd love to hear it!