We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
whereIsDistinctFrom
whereNotIsDistinctFrom
The IS DISTINCT FROM and IS NOT DISTINCT FROM terms simplify a query a lot for nullable columns:
IS DISTINCT FROM
IS NOT DISTINCT FROM
col IS DISTINCT FROM 'value' simplifies a query with nullable columns as it is a replacement for (col IS NULL OR col != 'value')
col IS DISTINCT FROM 'value'
(col IS NULL OR col != 'value')