Manuel Sugawara <masm@xxxxxxxxxxxxxxxxx> writes: > Tom Lane <tgl@xxxxxxxxxxxxx> writes: >> 8.2 is a good bit more conservative than previous releases about >> optimizing views involving volatile functions, so I'm wondering whether >> that could have anything to do with it ... > Just out of curiosity, why the change? People complained about getting wrong/surprising answers due to unexpected multiple evaluations of volatile functions. regards, tom lane