我正在尝试用mybatis更新java中的jsonb列。jsonb (external_group) cloumn时,我得到了以下错误。Cause: org.postgresql.util.PSQLException: The column index is out of range: 2, number of columns: 1.### The error may involve com.apds.mybatis.mapper.ServiceUserMapper.update-Inline
对于非jsonb</
下面是用于清除JSONB列中某些字段的查询。我试图把名字和姓拉面,所以我想用像md5(random()::text)这样的东西作为值。update people set
data = to_jsonb(data) || '{"firstName": "random_text", "lastName": "random_text