BIT_SET

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();

+---------+---------+---------+---------+
| bit_set | bit_set | bit_set | bit_set |
+---------+---------+---------+---------+
|       3 |       7 |       2 |       7 |
+---------+---------+---------+---------+

bitSet(inline(3), 2)

(3 | (1 * CAST(power(2, 2) AS int)))

(3 | (1 << 2))

bitOr(
  3,
  bitShiftLeft(1, 2)
)

(3 | shiftleft(1, 2))

bitor(
  3,
  (1 * CAST(power(2, 2) AS integer))
)

bit_set(3, 2)

bin_or(
  3,
  bin_shl(1, 2)
)

bitor(
  3,
  lshift(1, 2)
)

bitor(
  3,
  (1 * CAST(power(2, 2) AS int))
)

((3 + (1 * CAST(power(2, 2) AS number(10)))) - bitand(
  3,
  (1 * CAST(power(2, 2) AS number(10)))
))

bitor(
  3,
  bitshiftleft(1, 2)
)

set_bit(3, 2)

setbit(3, 2)

bitwise_or(
  3,
  bitwise_left_shift(1, 2)
)

/* UNSUPPORTED */

使用 jOOQ 3.21 生成。早期 jOOQ 版本的支持可能有所不同。 在我们的网站上翻译您自己的 SQL