PostgreSQL error code
PostgreSQL error 2203A
2203A is the SQLSTATE PostgreSQL reports for sql json member not found, in class 22, Data Exception.
| SQLSTATE | 2203A |
|---|---|
| Condition name | sql_json_member_not_found |
| Class | 22 — Data Exception |
Reproduce it, then fix it
In strict mode a missing key is an error. Lax mode, the default, returns no rows for it. Run the broken query to see the error, then switch to the fixed one. Edit either freely; every run is rolled back.
SELECT jsonb_path_query('{"name": "Mouse"}', 'strict $.price');SELECT jsonb_path_query('{"name": "Mouse"}', 'lax $.price');