Expand description
JSONB support
Modules§
- array_
elements - expand array into value rows
- array_
length - array length
- cast
- type conversions
- each
- expand object into key-value rows
- format_
json - jsonb->json
- get
- get by name
- keys
- extract object keys
- parse
- jsonb_parse
- path_
query - JSONPath query
Structs§
- Jsonb
Array Length - A scalar UDF that returns the number of elements in a JSONB array.
- Jsonb
AsF64 - A scalar UDF that casts a JSONB value to a f64.
- Jsonb
AsI64 - A scalar UDF that casts a JSONB value to an i64.
- Jsonb
AsString - A scalar UDF that casts a JSONB value to a string.
- Jsonb
Format Json - A scalar UDF that formats JSONB binary data as a JSON string.
- Jsonb
Get - A scalar UDF that retrieves a value from a JSONB object by name.
- Jsonb
Object Keys - A scalar UDF that extracts the keys from a JSONB object.
- Jsonb
Parse - A scalar UDF that parses a JSON string into a JSONB value.
- Jsonb
Path Query - A scalar UDF that returns all matches of a JSONPath expression on a JSONB value as a JSONB array.
- Jsonb
Path Query First - A scalar UDF that returns the first match of a JSONPath expression on a JSONB value.