FALSE is not NULL
Andreas WIsmann, August 07, 2019 - 7:40 am UTC
Respectively, in order to distinguish between Boolean FALSE and NULL:
my_varchar_variable := case boolean_var when true then 'true' when false then 'false' else NULL end;
August 08, 2019 - 2:27 am UTC
Good point.