Skip to main content

Overview

Relyt supports built-in functions and operators including window functions that can be used in window expressions. Functions supported by Relyt can be classified into the following three types:

Function typeSupportedDescriptionRemarks
IMMUTABLEYesDoes not modify the database, and always returns the same result if given the same argument values.N/A
STABLEYes, in most casesReturns the same result within a table scan, if given the same argument values.The returned results vary with database lookups and parameter values. Functions of the current_timestamp family are STABLE.
VOLATILERestrictedFunction values can change within a single table scan. For example, random(), timeofday()Any function with side effects is volatile, even if its result is predictable. For example, setval().