SELECT * FROM pet WHERE -- 核心条件:两个CatchTime值不相等,或data中无CatchTime字段 ( -- 1. 类型统一后对比(catch_time和data->CatchTime都转int4) (data->>'CatchTime')::int4 != catch_time::int4 -- 2. data中没有CatchTime字段(也需要筛选) OR NOT jsonb_exists(data, 'CatchTime') );