Conditional Expression Functions

function booland(decimal(38, 0), decimal(38, 0)) returns boolean

function boolnot(decimal(38, 0)) returns boolean

function boolor(decimal(38, 0), decimal(38, 0)) returns boolean

function boolxor(decimal(38, 0), decimal(38, 0)) returns boolean

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

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

function equal_null($1, $1) returns boolean
function equal_null(array, array) returns boolean

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

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

function iff(boolean, $1, $1) returns $1

function ifnull($1, $1) returns $1

function is_null_value(variant) returns boolean

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

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

function nullif($1, $1) returns $1

function nullifzero(decimal(38, 0)) returns decimal(38, 0)
function nullifzero(double) returns double

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

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

function regr_valx(double, double) returns double

function regr_valy(double, double) returns double

function zeroifnull(decimal(38, 0)) returns decimal(38, 0)
function zeroifnull(double) returns double