yql/essentials/tests/sql/suites/json/json_exists/common_syntax.sql


1
2
3
4
5
6
7
8
9
10
11
12

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

-- Null handling
SELECT
    JSON_EXISTS(NULL, "strict $.key"),
    JSON_EXISTS(Nothing(Json?), "strict $.key");

-- Casual select
$json = CAST(@@{"key": 128}@@ as Json);
SELECT
    JSON_EXISTS($json, "strict $.key");