Waiting for PostgreSQL 15 – SQL/JSON query functions
On 29th of March 2022, Andrew Dunstan committed patch: SQL/JSON query functions This introduces the SQL/JSON functions for querying JSON data using jsonpath expressions. The functions are: JSON_EXISTS() JSON_QUERY() JSON_VALUE() All of these functions only operate on jsonb. The workaround for now is to cast the argument to jsonb. JSON_EXISTS() tests … Continue reading “Waiting for PostgreSQL 15 – SQL/JSON query functions”