OPAL Misc Functions

Miscellaneous functions are those that do not fit in the other categories.

Function

Description

any_null

Returns a null value of type any.

coalesce

Return the first non-null argument or null if all are null.

editdistance

Returns the Levenshtein distance between str1 and str2.

frame

Specify the relative time frame for a window context.

frame_exact

Specify the relative time frame for a window context.

if

Return the second argument if condition# is true, otherwise return third argument.

if_null

Return the second argument if the first argument has the null value.

order_by

Specify the ordering when processing data.

parse_json

Parse the argument value as a JSON string.

position

Searches for the first occurrence of the second argument (needle) in the first argument (haystack) and, if successful, returns the

string

Generate a string representation of the argument value.

string_null

Returns a null value of type string.

variant_type_name

Given a variant value (typically, something you get from looking up a path or element in a JSON object or array,) determine what