GET_JSON_DOUBLE
Extracts a double value from a JSON object by a specified path.
Analyze Syntax
func.get_json_double(get_column(table, 'data'), '$.price')
Analyze Examples
func.get_json_double(get_column(table, 'data'), '$.price')
┌───────┐
│ 19.99 │
└───────┘
SQL Syntax
GET_JSON_DOUBLE(<data>, '$.price')
SQL Examples
SELECT GET_JSON_DOUBLE('{"price": 19.99}', '$.price');
┌───────┐
│ 19.99 │
└───────┘