PostgreSQL error code
PostgreSQL error 42883
42883 is the SQLSTATE PostgreSQL reports for undefined function, in class 42, Syntax Error or Access Rule Violation.
| SQLSTATE | 42883 |
|---|---|
| Condition name | undefined_function |
| Class | 42 — Syntax Error or Access Rule Violation |
Reproduce it, then fix it
These are the queries from the guide below. Run the broken query to see the error, then switch to the fixed one. Edit either freely; every run is rolled back.
SELECT o.id, c.first_name FROM demo.orders o JOIN demo.customers c ON c.email = o.customer_id;
SELECT o.id, c.first_name FROM demo.orders o JOIN demo.customers c ON c.id = o.customer_id;