Json Functions

`is_json_scalar`

Determine if json is a scalar (i.e. a JSON number, a JSON string, true, false or null). Supported Signatures

function is_json_scalar(json) returns boolean
function is_json_scalar(varchar) returns boolean

🔗 Official Documentation

`json_array_contains`

Determine if value exists in json (a string containing a JSON array). Supported Signatures

function json_array_contains(json, bigint) returns boolean
function json_array_contains(json, boolean) returns boolean
function json_array_contains(json, double) returns boolean
function json_array_contains(json, varchar) returns boolean
function json_array_contains(varchar, bigint) returns boolean
function json_array_contains(varchar, boolean) returns boolean
function json_array_contains(varchar, double) returns boolean
function json_array_contains(varchar, varchar) returns boolean

🔗 Official Documentation

`json_array_get`

Warning Supported Signatures

function json_array_get(json, bigint) returns json
function json_array_get(varchar, bigint) returns json

🔗 Official Documentation

`json_array_length`

Returns the array length of json (a string containing a JSON array). Supported Signatures

function json_array_length(json) returns bigint
function json_array_length(varchar) returns bigint

🔗 Official Documentation

`json_extract`

Evaluates the JSONPath-like expression json_path on json (a string containing JSON) and returns the result as a JSON string. Supported Signatures

function json_extract(json, jsonpath) returns json
function json_extract(varchar, jsonpath) returns json

🔗 Official Documentation

`json_extract_scalar`

Like json_extract(), but returns the result value as a string (as opposed to being encoded as JSON). The value referenced by json_path must be a scalar (boolean, number or string). Supported Signatures

function json_extract_scalar(json, jsonpath) returns varchar
function json_extract_scalar(varchar, jsonpath) returns varchar

🔗 Official Documentation

`json_format`

Returns the JSON text serialized from the input JSON value. This is inverse function to json_parse(). Supported Signatures

function json_format(json) returns varchar

🔗 Official Documentation

`json_parse`

Returns the JSON value deserialized from the input JSON text. This is inverse function to json_format(). Supported Signatures

function json_parse(varchar) returns json

🔗 Official Documentation

`json_size`

Like json_extract(), but returns the size of the value. For objects or arrays, the size is the number of members, and the size of a scalar value is zero. Supported Signatures

function json_size(json, jsonpath) returns bigint
function json_size(varchar, jsonpath) returns bigint

🔗 Official Documentation

Reference

SQL Functions

Json Functions

`is_json_scalar`

`json_array_contains`

`json_array_get`

`json_array_length`

`json_extract`

`json_extract_scalar`

`json_format`

`json_parse`

`json_size`

​is_json_scalar

​json_array_contains

​json_array_get

​json_array_length

​json_extract

​json_extract_scalar

​json_format

​json_parse

​json_size

`is_json_scalar`

`json_array_contains`

`json_array_get`

`json_array_length`

`json_extract`

`json_extract_scalar`

`json_format`

`json_parse`

`json_size`