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