st 7. 8. 2019 v 17:39 odesílatel Tom Lane <tgl@sss.pgh.pa.us> napsal:
Pavel Stehule <pavel.stehule@gmail.com> writes: > I should to use a cache accessed via fn_extra. There will be stored data > about function parameters (types). If I understand correctly, these data > should be stable in query, and then recheck is not necessary. Is it true?
I wouldn't trust that. You don't really know what the lifespan of a fn_extra cache is.
fn_extra cache cannot be longer than query. And if I understand well, then is not possible to change parameter types inside query?