FunctionsJSON

json_path_query

Evaluates a SQL/JSON path expression against a JSON document. Returns the JSON value(s) matched by the path as a JSON result.

json_path_query(…) → JSON

Kind · scalar

Evaluates a SQL/JSON path expression against a JSON document. Returns the JSON value(s) matched by the path as a JSON result.

Part of the JSON family.

json_path_match_tz

Evaluates a SQL/JSON path expression against a JSON document. Returns true if the path predicate evaluates to true for the document. Time-zone-aware variants use an explicit time zone when interpre…

json_path_query_array

Evaluates a SQL/JSON path expression against a JSON document. Returns all path matches collected into a JSON array.