postgresql null 值 不受查询条件约束

postgresql  null 值 不受查询条件约束

postgresql null 值 不受查询条件约束

 

select count(1) cnt from dm.algo_m_gg_1_prt_qycg_ebs_shasteel_cn where (minfo4 is null or length(minfo4)<5 ) and (page_type!=2 ) and length(page)>100;

 

select count(1) cnt from dm.algo_m_gg_1_prt_qycg_ebs_shasteel_cn where (minfo4 is null or length(minfo4)<5 ) and (page_type!=2 or page_type is null) and length(page)>100;

 

 

 

 

 

page_type 有的内容为null，条件page_type!=2，对这种值没有约束