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(). |