Expand description
SQL/JSON path query compiler and scalar UDFs SQL/JSON path query functions (F-SCHEMA-012).
Implements a basic JSON path compiler and two scalar UDFs:
jsonb_path_exists(jsonb, path_text) → booleanjsonb_path_match(jsonb, path_text) → boolean
The path language supports a PostgreSQL SQL/JSON subset:
$— root element.key— object member access[n]— array element by index[*]— wildcard array elements
Structs§
- Compiled
Json Path - A compiled SQL/JSON path expression.
- Jsonb
Path Exists Udf - Returns
trueif the JSON path matches any element in the JSONB value. - Jsonb
Path Match Udf jsonb_path_match(jsonb, path_text) → boolean
Enums§
- Json
Path Step - A single step in a compiled JSON path.