New versions: Dev (3.14) | Latest (3.13) | 3.12 | 3.11 | 3.10 | 3.9 | 3.8 | Old versions: 3.7 | 3.6 | 3.5 | 3.4 | 3.3 | 2.6

Bitwise functions

Available in ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

Most databases only support a few bitwise operations, while others ship with the full set of operators. jOOQ's API includes most bitwise operations as listed below. In order to avoid ambiguities with conditional operators, most bitwise functions are prefixed with "bit"

Table of contents

4.8.11.1.
BIT_COUNT
4.8.11.2.
BIT_AND
4.8.11.3.
BIT_NAND
4.8.11.4.
BIT_NOR
4.8.11.5.
BIT_NOT
4.8.11.6.
BIT_OR
4.8.11.7.
SHL
4.8.11.8.
SHR
4.8.11.9.
BIT_XNOR
4.8.11.10.
BIT_XOR

The jOOQ User Manual. Multiple Pages : SQL building : Column expressions : Bitwise functionsprevious : next
The jOOQ Logo