JSON Scalar

json_array_length()

Reference: DuckDB 2.0.0

Arguments & returns

6 overloads

json_array_length(json)

Scalar
Overload link json Returns
#01 JSON UBIGINT
#02 VARCHAR UBIGINT

json_array_length(json, path)

Scalar
Overload link jsonpath Returns
#03 JSONVARCHAR UBIGINT
#04 JSONVARCHAR[] UBIGINT[]
#05 VARCHARVARCHAR UBIGINT
#06 VARCHARVARCHAR[] UBIGINT[]