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 type | Supported | Description | Remarks |
---|---|---|---|
IMMUTABLE | Yes | Does not modify the database, and always returns the same result if given the same argument values. | N/A |
STABLE | Yes, in most cases | Returns 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 . |
VOLATILE | Restricted | Function 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() . |