BIT_GET

SELECT
  bit_get(3, 0),
  bit_get(3, 2);

create.select(
  bitGet(inline(3), 0),
  bitGet(inline(3), 2)).fetch();

+---------+---------+
| bit_get | bit_get |
+---------+---------+
|       1 |       0 |
+---------+---------+

bitGet(inline(3), 2)

((3 & (1 * CAST(power(2, 2) AS int))) / CAST(power(2, 2) AS int))

((3 & (1 << 2)) >> 2)

bitTest(3, 2)

bit_get(3, 2)

(bitand(
  3,
  (1 * CAST(power(2, 2) AS integer))
) / CAST(power(2, 2) AS integer))

CASE bit_check(3, 2)
  WHEN TRUE THEN 1
  WHEN FALSE THEN 0
END

bin_shr(
  bin_and(
    3,
    bin_shl(1, 2)
  ),
  2
)

CASE bitget(3, 2)
  WHEN TRUE THEN 1
  WHEN FALSE THEN 0
END

(bitand(
  3,
  (1 * CAST(power(2, 2) AS int))
) / CAST(power(2, 2) AS int))

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

bitshiftright(
  bitand(
    3,
    bitshiftleft(1, 2)
  ),
  2
)

get_bit(3, 2)

getbit(3, 2)

bitwise_right_shift(
  bitwise_and(
    3,
    bitwise_left_shift(1, 2)
  ),
  2
)

/* UNSUPPORTED */

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