postgresql/no-equality-with-null

Why this matters

Comparing with `NULL` using `=`, `<>`, or `!=` always returns NULL (not true), so the predicate silently filters every row. Use the three-valued-logic-aware `IS NULL` / `IS NOT NULL` instead.

Examples

SELECT * FROM t WHERE x = NULL;

SELECT * FROM t WHERE x <> NULL;

SELECT * FROM t WHERE NULL = x;

SELECT * FROM t WHERE x IS NULL;

SELECT * FROM t WHERE x IS NOT NULL;

Configure it

// eslint.config.js
import postgresql from "eslint-plugin-postgresql";

export default [
  {
    files: ["**/*.sql"],
    languageOptions: {
      parser: postgresql.configs.recommended.languageOptions.parser,
    },
    plugins: { postgresql },
    rules: {
      "postgresql/no-equality-with-null": "error",
    },
  },
];

Options

This rule has no options.