yql/essentials/tests/sql/suites/json/jsondocument/json_value.sql


1
2
3
4
5
6
7
8
9
10

/* syntax version 1 */
/* postgres can not */

$json = JsonDocument(@@{"a": {"b": 1}, "c": 2}@@);

SELECT
    JSON_VALUE($json, "$.c"),
    JSON_VALUE($json, "$.b"),
    JSON_VALUE($json, "$.a"),
    JSON_VALUE(CAST(NULL as JsonDocument), "$.a");