FunctionsJSON

json_has

Checks object keys, JSON paths, or array element membership depending on the input document shape.

json_has(…) → Bool

Kind · scalar

Checks object keys, JSON paths, or array element membership depending on the input document shape.

Part of the JSON family.

json_extract_uint

Extracts the JSON value at the given path and returns it as an unsigned integer. If the path is missing, the JSON is invalid, or the value is negative/not an integer/overflows, the result is NULL.

json_hash

Computes a deterministic 64-bit hash of the normalized JSON token stream.