Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> writes:
> We know volatile is very harmful for optimizers and it is the default
> value (and safest value) if the user doesn't provide that. Asking user
> to set the value is not a good experience, is it possible to auto-generate
> the value for it rather than use the volatile directly for user defined
> function. I
> think it should be possible, we just need to scan the PlpgSQL_stmt to see
> if there
> is a volatile function?
Are you familiar with the halting problem? I don't see any meaningful
difference here.
regards, tom lane