FunctionsJSON
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_exists(…) → BoolKind · scalar
Evaluates a SQL/JSON path expression against a JSON document. Returns true if the path matches at least one item in the document.
Part of the JSON family.
json_object_keys
Returns the keys of a JSON object. In set-returning contexts this produces one row per key; otherwise it may return an array of keys.
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…