Reading this post, the author references a "non-volatile" expression, after researching a bit, I'm still not sure what it is. What is meant by a non-volatile expression in Postgresql?
Asked
Active
Viewed 2,016 times
1 Answers
5
"Immutable" expressions resolve to the same value always. Like 2 + 3.
"Stable" expressions resolve to the same value within a single table scan. Like: now().
"Volatile" expressions can resolve to a different value for each evaluation. Like: clock_timestamp().
"Non-volatile" would be in one of the first two categories.
Related:
Erwin Brandstetter
- 185,527
- 28
- 463
- 633