select coalesce(a, 'no') from ( values (null), ('yes'), ) t(a); ------- no yes
select nullif(a, 'no') from ( values ('no'), ('yes'), ) t(a); ------- null yes