PostgreSQL error code
PostgreSQL error 2203C
2203C is the SQLSTATE PostgreSQL reports for sql json object not found, in class 22, Data Exception.
| SQLSTATE | 2203C |
|---|---|
| Condition name | sql_json_object_not_found |
| Class | 22 — Data Exception |
Reproduce it, then fix it
.* lists an object’s members, but the document is an array. Step into the array with [*] first. 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('[{"sku": "A1"}]', 'strict $.*');SELECT jsonb_path_query('[{"sku": "A1"}]', 'strict $[*].*');