I'm not sure of the right syntax to use.
select * from tlb where flag is NULL
select * from tlb where flag = NULL
Is the answer the same for oracle, sqlserver and Postgres?
Questions on Programmers Stack Exchange are expected to relate to software development within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.
Use the SQL standard
Quote from the Postgresql docs: