Specifies that the function returns identical results for identical inputs.
DETERMINISTIC and NOT DETERMINISTIC are optional and can only be specified once per function definition.
- NOT
- Specifies that the function does not always return identical results for identical inputs.
For example, if the function calls a random number generator as part of its processing, then the results of a function call cannot be known in advance of making the call and the function is NOT DETERMINISTIC.
The default is NOT DETERMINISTIC.