json_path_query_tz
Evaluates a SQL/JSON path expression against a JSON document. Returns the JSON value(s) matched by the path as a JSON result. Time-zone-aware variants use an explicit time zone when interpreting te…
json_path_query_tz(…) → JSONKind · scalar
Evaluates a SQL/JSON path expression against a JSON document. Returns the JSON value(s) matched by the path as a JSON result. 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_first_tz
Evaluates a SQL/JSON path expression against a JSON document. Returns the first path match (or NULL if there is no match). Time-zone-aware variants use an explicit time zone when interpreting tempo…
json_pretty
Formats a JSON value as a human-readable string with indentation and line breaks. Use this for debugging and logs, not for stable storage formats.