JSON Scalar

json_exists()

Arguments & returns

4 overloads

Scalar

Overload link	`col0`	`col1`	Returns
#01	`JSON`	`VARCHAR`	`BOOLEAN`
#02	`JSON`	`VARCHAR[]`	`BOOLEAN[]`
#03	`VARCHAR`	`VARCHAR`	`BOOLEAN`
#04	`VARCHAR`	`VARCHAR[]`	`BOOLEAN[]`

SELECT JSONB_EXISTS('{"a": [1,2,3]}', 'a')

In DuckDB

SELECT JSON_EXISTS('{"a": [1,2,3]}', '$.a')