DB
FunctionsJSON

json_path_exists_tz

Evaluates a SQL/JSON path expression against a JSON document. Returns true if the path matches at least one item in the document. Time-zone-aware variants use an explicit time zone when interpretin…

json_path_exists_tz(…) → Bool

Kind · scalar

Evaluates a SQL/JSON path expression against a JSON document. Returns true if the path matches at least one item in the document. 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_exists

Evaluates a SQL/JSON path expression against a JSON document. Returns true if the path matches at least one item in the document.

json_path_match

Evaluates a SQL/JSON path expression against a JSON document. Returns true if the path predicate evaluates to true for the document.