undefined_function operator does not exist: … — 42883

Symptoms

You used an operator (such as =, >, ||, or @>) with operand types that have no matching operator definition, and no implicit cast can bridge the gap. PostgreSQL reports SQLSTATE 42883 and usually adds a hint to add an explicit cast.

• The query aborts at parse/analysis time.
• The message names both operand types, e.g. integer = text.
• Often a hint follows: “You might need to add explicit type casts.”

What the server log shows

ERROR:  operator does not exist: integer = text
LINE 1: SELECT * FROM users WHERE id = $1;
                                     ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.

Why PostgreSQL raises this — what the manual says

As Section 10.2 Operators explains:

No operator was found whose name and operand types match the call; PostgreSQL could not locate an exact or implicitly-castable operator, so the expression’s operand types likely need an explicit cast.

Operator resolution looks up candidates by name and argument types, then applies implicit-cast rules. PostgreSQL deliberately removed many cross-type implicit casts (notably text ↔ numeric) to avoid surprising results, so comparisons between unrelated types now fail with 42883 rather than coercing silently.

Common causes

• Comparing a number against a text/varchar column (or a string literal passed for a numeric parameter).
• Using a JSON/array/range operator on a column whose type does not define it.
• A driver that binds all parameters as text ($1 with no cast).
• A dropped or missing extension that previously supplied the operator.

How to fix it

1. Add an explicit cast on one side: WHERE id = $1::int or WHERE code = 42::text.
2. Fix the column type if the data is really numeric stored as text (ALTER TABLE … ALTER COLUMN … TYPE).
3. For JSON/array/range operators, confirm the column type and required extension are installed.
4. In application code, bind parameters with the correct type rather than as strings.

Diagnostic query

-- List operators available for a given left/right type pair
SELECT oprname, oprleft::regtype, oprright::regtype
FROM pg_operator
WHERE oprname = '=' AND oprleft = 'integer'::regtype;

Related & next steps

• SQLSTATE 42883 — Undefined Function (full reference)
• Message: function … does not exist
• Glossary: Type cast

Reference: PostgreSQL 18 Section 10.2 “Operators”.