When comparing boolean values in PostgreSQL we use the comparison operator =.
This is all well but when I want to check against matching NULL values what should I use?
I have used IS NOT DISTINCT FROM when comparing integers that have to match if both are NULL but is it a correct way to go when dealing with boolean values?
I have used IS NOT DISTINCT FROM when comparing integers that have to match if both are NULL but is it a corract way to go when dealing with boolean values?
I see no reason why not. :)
x IS NOT DISTINCT FROM y is basically short-hand for (x = y) OR (x IS NULL AND y IS NULL)
Use is null clause. Like this:
select * from my_table where my_booleae_field is null
Try using coalesce
Like:
where coalesce(your_field, true) = true
Then null values and boolean true will pass the statement
distinct fromalso works with booleans:is not distinct from true