Skip to main content

Module json_path

Module json_path 

Source
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) → boolean
  • jsonb_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§

CompiledJsonPath
A compiled SQL/JSON path expression.
JsonbPathExistsUdf
Returns true if the JSON path matches any element in the JSONB value.
JsonbPathMatchUdf
jsonb_path_match(jsonb, path_text) → boolean

Enums§

JsonPathStep
A single step in a compiled JSON path.