JSON Functions

bool

Supported Signatures

function bool(json) returns bool

🔗 Official Documentation

float64

Supported Signatures

function float64(json) returns double

🔗 Official Documentation

int64

Supported Signatures

function int64(json) returns bigint

🔗 Official Documentation

json_extract

Supported Signatures

function json_extract(string, string) returns json

🔗 Official Documentation

json_extract_array

Supported Signatures

function json_extract_array(json) returns array<json>
function json_extract_array(json, string) returns array<json>

🔗 Official Documentation

json_extract_scalar

Supported Signatures

function json_extract_scalar(json) returns string
function json_extract_scalar(json, string) returns string

🔗 Official Documentation

json_extract_string_array

Supported Signatures

function json_extract_string_array(json) returns array<string>
function json_extract_string_array(json, string) returns array<string>

🔗 Official Documentation

json_query

Supported Signatures

function json_query(json, string) returns json

🔗 Official Documentation

json_query_array

Supported Signatures

function json_query_array(json, string) returns array<json>
function json_query_array(json) returns array<json>

🔗 Official Documentation

json_type

Supported Signatures

function json_type(json) returns string

🔗 Official Documentation

json_value

Supported Signatures

function json_value(json, string) returns string
function json_value(json) returns string

🔗 Official Documentation

json_value_array

Supported Signatures

function json_value_array(json, string) returns array<string>
function json_value_array(json) returns array<string>

🔗 Official Documentation

parse_json

Supported Signatures

function parse_json(string) returns json

🔗 Official Documentation

string

Supported Signatures

function string $1($1) returns string
	where $1 in (timestamp, json)
function string $1($1, time_zone string) returns string
	where $1 in (timestamp, json)

🔗 Official Documentation

to_json_string

Supported Signatures

function to_json_string($1) returns string
function to_json_string($1, pretty_print bool) returns string

🔗 Official Documentation