OPAL Misc Functions

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

Function

Description

any_null

Returns a null value of type any.

asc

Specify the ordering as ascending when processing data.

coalesce

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

desc

Specify the ordering as descending when processing data.

editdistance

Returns the Levenshtein distance between str1 and str2.

frame

Specify the approximate relative time frame for a window context.

frame_exact

Specify the exact relative time frame for a window context.

if

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

if_null

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

make_object

Turn a sequence of name:value elements into an object.

on

on is a special function used to specify the join condition for some join verbs.

order_by

Specify the ordering when processing data.

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