Immutable (invariant) functions

When run with a given set of arguments, immutable functions such as AVG() always produce the same result, regardless of environment or session settings such as locale. Some immutable functions can take an optional stable argument; in this case they are treated as stable functions.