DB
FunctionsJSON

json_path_query_array_tz

Evaluates a SQL/JSON path expression against a JSON document. Returns all path matches collected into a JSON array. Time-zone-aware variants use an explicit time zone when interpreting temporal lit…

json_path_query_array_tz(…) → JSON

Kind · scalar

Evaluates a SQL/JSON path expression against a JSON document. Returns all path matches collected into a JSON array. Time-zone-aware variants use an explicit time zone when interpreting temporal literals or casts inside the path expression.

Part of the JSON family.

json_path_query_array

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

json_path_query_first

Evaluates a SQL/JSON path expression against a JSON document. Returns the first path match (or NULL if there is no match).