postgresql/prefer-cast-operator

Why this matters

PostgreSQL accepts both forms; this rule picks one and rewrites the other. Default is the operator form `x::int`. Switch with the `form` option.

Examples

SELECT CAST(x AS integer) FROM t;

SELECT CAST(x AS varchar(255)) FROM t;

SELECT x::integer FROM t;

SELECT x::numeric(10, 2) FROM t;

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/prefer-cast-operator": [
        "warn",
        {
          form: "operator",
        },
      ],
    },
  },
];

Options

form "operator" | "function" default: "operator"

Which form of cast to enforce. `operator` rewrites `CAST(x AS T)` to `x::T`; `function` rewrites the other direction.