FunctionsJSON

json_extract_bool

Extracts the JSON value at the given path and returns it as a boolean. If the path is missing, the JSON is invalid, or the value cannot be represented as a boolean, the result is NULL.

json_extract_bool(…) → Bool

Kind · scalar

Extracts the JSON value at the given path and returns it as a boolean. If the path is missing, the JSON is invalid, or the value cannot be represented as a boolean, the result is NULL.

Part of the JSON family.

json_extract_array_raw

Extracts and returns the raw JSON array fragment from the selected path.

json_extract_float

Extracts the JSON value at the given path and returns it as a floating-point number. If the path is missing, the JSON is invalid, or the value is not numeric, the result is NULL.