On 22.11.2019 11:05, Pavel Stehule wrote:
We should to distinguish between bad result and not well optimized plan.
If it is not possible to implement runtime check tha timmutable function is not making any changes in database.
Please notice, that even right now without any get snapshot optimization Postgres can produce incorrect result in case of incorrectly specidied immutable or stable qualifiers.
--
Konstantin Knizhnik
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company