FunctionsJSON
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.
json_path_match(…) → BoolKind · scalar
Evaluates a SQL/JSON path expression against a JSON document. Returns true if the path predicate evaluates to true for the document.
Part of the JSON family.
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_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…