JSON Functions

  • reference
    +

    DECODE_JSON(expression)

    Unmarshals the JSON-encoded string into a SQL++ value. The empty string is MISSING.

    ENCODE_JSON(expression)

    Marshals the SQL++ value into a JSON-encoded string. MISSING becomes the empty string.

    ENCODED_SIZE(expression)

    Number of bytes in an uncompressed JSON encoding of the value. The exact size is implementation-dependent. Always returns an integer, and never MISSING or NULL. Returns 0 for MISSING.

    POLY_LENGTH(expression)

    Returns length of the value after evaluating the expression. The exact meaning of length depends on the type of the value:

    • MISSING: MISSING

    • NULL: NULL

    • String: The length of the string.

    • Array: The number of elements in the array.

    • Object: The number of name/value pairs in the object

    • Any other value: NULL