Other Expressions

function add_months(varchar, bigint) returns timestamp

function any_value($1) returns $1

function array($1, ...) returns super

function array_flatten(super) returns super

function bpcharcmp(varchar, varchar) returns bigint

function bttext_pattern_cmp(varchar, varchar) returns bigint

function can_json_parse(varchar) returns boolean

function cbrt(float) returns float

function ceiling(float) returns float

function charindex(varchar, varchar) returns bigint

function collate(varchar, varchar) returns varchar

function cot(float) returns float

function crc32(varchar) returns varchar

function decimal_precision(super) returns bigint

function decimal_scale(super) returns bigint

function degrees(float) returns float

function dexp(float) returns float

function difference(varchar, varchar) returns bigint

function dlog1(float) returns float

function dlog10(float) returns float

function farmfingerprint64(varchar) returns bigint

function fnv_hash(varchar) returns bigint

function from_hex(varchar) returns varbyte

function from_varbyte(varbyte, varchar) returns varbyte

function func_sha1(varchar) returns bigint

function getbit(varbyte, bigint) returns bigint

function greatest($1, ...) returns $1

function interval_cmp(varchar, varchar) returns bigint

function is_array(super) returns boolean

function is_bigint(super) returns boolean

function is_boolean(super) returns boolean

function is_char(super) returns boolean

function is_decimal(super) returns boolean

function is_float(super) returns boolean

function is_object(super) returns boolean

function is_scalar(super) returns boolean

function is_smallint(super) returns boolean

function is_valid_json(varchar) returns boolean

function is_valid_json_array(varchar) returns boolean

function is_varchar(super) returns boolean

function json_extract_array_element_text(varchar, bigint) returns varchar
function json_extract_array_element_text(varchar, bigint, boolean) returns varchar

function json_extract_path_text(varchar, varchar) returns varchar
function json_extract_path_text(varchar, varchar, varchar) returns varchar
function json_extract_path_text(varchar, varchar, varchar, varchar) returns varchar
function json_extract_path_text(varchar, varchar, varchar, varchar, varchar) returns varchar
function json_extract_path_text(varchar, varchar, varchar, varchar, varchar, varchar) returns varchar
function json_extract_path_text(varchar, varchar, boolean) returns varchar
function json_extract_path_text(varchar, varchar, varchar, boolean) returns varchar
function json_extract_path_text(varchar, varchar, varchar, varchar, boolean) returns varchar
function json_extract_path_text(varchar, varchar, varchar, varchar, varchar, boolean) returns varchar
function json_extract_path_text(varchar, varchar, varchar, varchar, varchar, varchar, boolean) returns varchar

function json_parse(varchar) returns super

function json_serialize($1) returns varchar

function json_serialize_to_varbyte($1) returns varbyte

function json_size(super) returns bigint

function json_typeof(super) returns varchar

function last_day(varchar) returns date

function least($1, ...) returns $1

function len(varchar) returns bigint

function md5(varchar) returns bigint

function mod(bigint, bigint) returns bigint

function months_between(varchar, varchar) returns float

function murmur3_32_hash(varchar) returns bigint
function murmur3_32_hash(varchar, bigint) returns bigint

function next_day(varchar, varchar) returns date

function nvl($1, ...) returns $1

function nvl2($1, $2, $2) returns $2

function octetindex(varchar, varchar) returns bigint

function pi() returns float

function quote_ident(varchar) returns varchar

function quote_literal(varchar) returns varchar

function radians(float) returns float

select reclassify(12345, 'pii.clear_text', 'pii.masked') as value; -- value '12345'

function reclassify($1, varchar, varchar) returns $1

function regexp_instr(varchar, varchar) returns bigint
function regexp_instr(varchar, varchar, bigint) returns bigint
function regexp_instr(varchar, varchar, bigint, bigint) returns bigint
function regexp_instr(varchar, varchar, bigint, bigint, bigint) returns bigint
function regexp_instr(varchar, varchar, bigint, bigint, bigint, varchar) returns bigint

function regexp_substr(varchar, varchar) returns varchar
function regexp_substr(varchar, varchar, varchar) returns varchar
function regexp_substr(varchar, varchar, varchar, bigint) returns varchar
function regexp_substr(varchar, varchar, varchar, bigint, varchar) returns varchar

function replicate(varchar, bigint) returns varchar

function sha(varchar) returns bigint

function sha1(varchar) returns bigint

function sha2(varchar, bigint) returns bigint

function sign(float) returns bigint

function size($1) returns bigint

function soundex(varchar) returns varchar

function split_to_array(varchar, varchar) returns super

function strtol(varchar, bigint) returns bigint

function subarray(super, bigint, bigint) returns super

function text_to_int_alt(varchar) returns bigint
function text_to_int_alt(varchar, varchar) returns bigint

function text_to_numeric_alt(varchar) returns float
function text_to_numeric_alt(varchar, varchar) returns float
function text_to_numeric_alt(varchar, bigint, bigint) returns float
function text_to_numeric_alt(varchar, varchar, bigint, bigint) returns float

function textlen(varchar) returns bigint

function to_char($1, varchar) returns varchar

function to_hex(varbyte) returns varchar
function to_hex(bigint) returns varchar

function to_number(varchar, varchar) returns float

function to_varbyte(varchar, varchar) returns varbyte

function trunc(varchar) returns date