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 in the FAQ. 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 closed questions here.
Use the SQL standard
Quote from the Postgresql docs: