common_syntax.sql 264 B

123456789101112
  1. /* syntax version 1 */
  2. /* postgres can not */
  3. -- Null handling
  4. SELECT
  5. JSON_EXISTS(NULL, "strict $.key"),
  6. JSON_EXISTS(Nothing(Json?), "strict $.key");
  7. -- Casual select
  8. $json = CAST(@@{"key": 128}@@ as Json);
  9. SELECT
  10. JSON_EXISTS($json, "strict $.key");