使用Postgres 14.5（和jOOQ 3.17.6），假设以下options表定义：

CREATE TABLE options (
  letter       uuid  NOT NULL,
  is_selected  bool  NULL,
);

...with data：

| letter | is_selected |
| A      | (null)      |
| B      | (null)      |
| C      | (null)      |
| ...    | (null)      |

如何编写一个更新来指示选择了B而其他值没有被选择？
我尝试了几件事：

jooq
  .update(OPTIONS)
  .set(OPTIONS.IS_SELECTED, OPTIONS.LETTER == val("B")) <-- this didn't work because I
                                                            think this a memory address
                                                            comparison

  .set(OPTIONS.IS_SELECTED, OPTIONS.LETTER.equal(val("B"))) <-- this doesn't compile

  .execute()