In my database table I am having one boolean column. which have some transaction with will False, True and Null.
These are the cases i have tried:
Case:1
select * from table_name where
boolean_column is null;
works well. Give the result with all transaction having null value for that column.
Case:2
select *from table_name where boolean_column = False;
Works well. Gives result with all the transaction having False value for that column.
Case:3 This is requirement which does not works. I want all the transaction having value False and Null.
I have tried these.
i) select *from table_name where boolean_column is False or Null;
Which only gives the result for False it does not shows null records.
ii) select *from table_name where boolean_column is Null or False;
*Which only gives the result for null it does not shows records with False value. *
iii) select *from table_name where boolean_column is Null or boolean_column = False;
This is simply display all the transaction does not applied any condition at all.
How to resolve this issue. Any guidance appreciated.
Thanks in Advance.
Rgds, Anil.