java直接sql更新pgsql的jsonb字段

   <update id="updateByIds">
        update tmp
        set extend=  #{extend}::jsonb,
        updated = now()
        where id in
        <foreach collection="ids" item="id" open="(" close=")" separator=",">
            #{id}
        </foreach>
    </update>