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